eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_DK_ARCHIVE_EHOL dependencies on FND_NUMBER

Line 1041: SELECT fnd_number.canonical_to_number(AEI_INFORMATION3)

1037:
1038: rg_csr_assignments_dtl csr_assignments_dtl%rowtype;
1039:
1040: CURSOR cur_get_hol_pay_perc(p_effective_date DATE, p_asg_id NUMBER) IS
1041: SELECT fnd_number.canonical_to_number(AEI_INFORMATION3)
1042: FROM PER_ASSIGNMENT_EXTRA_INFO
1043: WHERE
1044: ASSIGNMENT_ID = p_asg_id
1045: AND INFORMATION_TYPE = 'DK_EHOLC_HPAY_RATE'

Line 1054: ,fnd_number.canonical_to_number(hoi2.ORG_INFORMATION3) HOURLY_ACCR_RATE

1050:
1051: /* Cursor to fetch the Legal Employer level Holiday Entitlement */
1052: CURSOR csr_get_hol_entit(p_le_id NUMBER, p_effective_date DATE, p_business_group_id NUMBER) IS
1053: SELECT hoi2.ORG_INFORMATION1 DEFAULT_WORK_PATT
1054: ,fnd_number.canonical_to_number(hoi2.ORG_INFORMATION3) HOURLY_ACCR_RATE
1055: ,fnd_number.canonical_to_number(hoi2.ORG_INFORMATION4) SAL_ALLOW_RATE
1056: FROM HR_ORGANIZATION_UNITS hou
1057: , HR_ORGANIZATION_INFORMATION hoi1
1058: , HR_ORGANIZATION_INFORMATION hoi2

Line 1055: ,fnd_number.canonical_to_number(hoi2.ORG_INFORMATION4) SAL_ALLOW_RATE

1051: /* Cursor to fetch the Legal Employer level Holiday Entitlement */
1052: CURSOR csr_get_hol_entit(p_le_id NUMBER, p_effective_date DATE, p_business_group_id NUMBER) IS
1053: SELECT hoi2.ORG_INFORMATION1 DEFAULT_WORK_PATT
1054: ,fnd_number.canonical_to_number(hoi2.ORG_INFORMATION3) HOURLY_ACCR_RATE
1055: ,fnd_number.canonical_to_number(hoi2.ORG_INFORMATION4) SAL_ALLOW_RATE
1056: FROM HR_ORGANIZATION_UNITS hou
1057: , HR_ORGANIZATION_INFORMATION hoi1
1058: , HR_ORGANIZATION_INFORMATION hoi2
1059: WHERE hou.business_group_id = p_business_group_id

Line 1466: SELECT fnd_number.canonical_to_number(substr(max(lpad(paa.action_sequence,15,'0')||paa.assignment_action_id),16)) asg_action_id

1462: WHERE PAYROLL_ID = p_payroll_id
1463: AND p_date_earned BETWEEN ppf.EFFECTIVE_START_DATE AND ppf.EFFECTIVE_END_DATE;
1464:
1465: CURSOR cur_max_asg_act_id(p_assignment_id NUMBER, p_start_date DATE, p_end_date DATE) IS
1466: SELECT fnd_number.canonical_to_number(substr(max(lpad(paa.action_sequence,15,'0')||paa.assignment_action_id),16)) asg_action_id
1467: FROM pay_assignment_actions paa,
1468: pay_payroll_actions ppa
1469: WHERE ppa.payroll_action_id = paa.payroll_action_id
1470: and paa.assignment_id = p_assignment_id