APPS.PAY_NL_REM_REPORT dependencies on PER_ALL_ASSIGNMENTS_F

Line 532: per_all_assignments_f paa

528: ptp.end_date,
529: ptp.period_name
530: FROM
531: per_time_periods ptp,
532: per_all_assignments_f paa
533: WHERE paa.assignment_id = asg_id
534: AND ptp.end_date between paa.effective_start_date
535: AND paa.effective_end_date
536: AND paa.payroll_id = ptp.payroll_id

Line 1067: CURSOR cur_get_lhd_details(c_assignment_id per_all_assignments_f.assignment_id%TYPE) IS

1063: --=============================================================================
1064: /***********************************************************
1065: To get Labour Handicap Discount
1066: ***********************************************************/
1067: CURSOR cur_get_lhd_details(c_assignment_id per_all_assignments_f.assignment_id%TYPE) IS
1068: SELECT paei.aei_information3 lhd_type
1069: ,fnd_date.canonical_to_date (paei.aei_information1) date_from
1070: ,fnd_date.canonical_to_date (paei.aei_information2) date_to
1071: FROM per_assignment_extra_info paei

Line 1082: CURSOR cur_get_ttd_details(c_assignment_id per_all_assignments_f.assignment_id%TYPE) IS

1078: --=============================================================================
1079: /***********************************************************
1080: To get Temporary Tax Discount
1081: ***********************************************************/
1082: CURSOR cur_get_ttd_details(c_assignment_id per_all_assignments_f.assignment_id%TYPE) IS
1083: SELECT paei.aei_information3 ttd_type
1084: ,FND_DATE.CANONICAL_TO_DATE(paei.aei_information1) date_from
1085: ,FND_DATE.CANONICAL_TO_DATE(paei.aei_information2) date_to
1086: FROM per_assignment_extra_info paei

Line 1094: CURSOR cur_wage_table_det(c_assignment_id per_all_assignments_f.assignment_id%TYPE) IS

1090: AND paei.assignment_id = c_assignment_id
1091: AND paei.aei_information3 = '2'
1092: ORDER BY paei.aei_information1;
1093: --=============================================================================
1094: CURSOR cur_wage_table_det(c_assignment_id per_all_assignments_f.assignment_id%TYPE) IS
1095: SELECT DISTINCT
1096: paa2.assignment_id assignmentid
1097: ,paa2.effective_start_date effectivefrom
1098: ,paa2.effective_end_date effectiveto

Line 1100: FROM per_all_assignments_f paa1

1096: paa2.assignment_id assignmentid
1097: ,paa2.effective_start_date effectivefrom
1098: ,paa2.effective_end_date effectiveto
1099: ,sck2.segment4 wagetaxdiscount
1100: FROM per_all_assignments_f paa1
1101: ,per_all_assignments_f paa2
1102: ,hr_soft_coding_keyflex sck1
1103: ,hr_soft_coding_keyflex sck2
1104: WHERE l_reporting_date > paa2.effective_start_date

Line 1101: ,per_all_assignments_f paa2

1097: ,paa2.effective_start_date effectivefrom
1098: ,paa2.effective_end_date effectiveto
1099: ,sck2.segment4 wagetaxdiscount
1100: FROM per_all_assignments_f paa1
1101: ,per_all_assignments_f paa2
1102: ,hr_soft_coding_keyflex sck1
1103: ,hr_soft_coding_keyflex sck2
1104: WHERE l_reporting_date > paa2.effective_start_date
1105: AND (

Line 1110: FROM per_all_assignments_f

1106: (
1107: paa2.effective_start_date =
1108: (
1109: SELECT min (effective_start_date)
1110: FROM per_all_assignments_f
1111: WHERE assignment_id = paa2.assignment_id
1112: )
1113: )
1114: OR (

Line 1130: CURSOR cur_pay_period(c_assignment_id per_all_assignments_f.assignment_id%TYPE) IS

1126: AND paa2.assignment_id = c_assignment_id
1127: AND sck2.segment4 IS NOT NULL
1128: ORDER BY effectivefrom;
1129: --=============================================================================
1130: CURSOR cur_pay_period(c_assignment_id per_all_assignments_f.assignment_id%TYPE) IS
1131: SELECT ppa.payroll_action_id pact_id
1132: ,ppa.effective_date eff_date
1133: ,paa.assignment_action_id assact_id
1134: ,paa.assignment_id asg_id

Line 1158: CURSOR cur_retro_period_det(c_assignment_id per_all_assignments_f.assignment_id%TYPE,

1154: AND ppa.date_earned between ptp.start_date and ptp.end_date
1155: ORDER BY period_name
1156: ,pact_id;
1157: --=============================================================================
1158: CURSOR cur_retro_period_det(c_assignment_id per_all_assignments_f.assignment_id%TYPE,
1159: c_pact_id pay_payroll_actions.payroll_action_id%TYPE,
1160: c_assact_id pay_assignment_actions.assignment_action_id%TYPE
1161: ) IS
1162: SELECT ptp.start_date retro_period

Line 1219: l_numiv_override per_all_assignments_f.assignment_number%TYPE;

1215: r_retro_period_det cur_retro_period_det%ROWTYPE;
1216: r_get_lhd_details cur_get_lhd_details%ROWTYPE;
1217: r_get_ttd_details cur_get_ttd_details%ROWTYPE;
1218: y NUMBER;
1219: l_numiv_override per_all_assignments_f.assignment_number%TYPE;
1220: l_emp_seq per_all_assignments_f.assignment_number%TYPE;
1221:
1222: BEGIN
1223:

Line 1220: l_emp_seq per_all_assignments_f.assignment_number%TYPE;

1216: r_get_lhd_details cur_get_lhd_details%ROWTYPE;
1217: r_get_ttd_details cur_get_ttd_details%ROWTYPE;
1218: y NUMBER;
1219: l_numiv_override per_all_assignments_f.assignment_number%TYPE;
1220: l_emp_seq per_all_assignments_f.assignment_number%TYPE;
1221:
1222: BEGIN
1223:
1224: /***********************************************************

Line 1833: ,per_all_assignments_f paa

1829: CURSOR csr_person_details IS
1830: SELECT DISTINCT
1831: papf.national_identifier sofi_number
1832: FROM per_all_people_f papf
1833: ,per_all_assignments_f paa
1834: ,per_periods_of_service pps
1835: ,pay_payroll_actions ppa
1836: ,pay_assignment_actions asg_act
1837: ,pay_all_payrolls_f ppf

Line 1894: ,per_all_assignments_f paa

1890: ,NVL (paa.establishment_id
1891: ,ppf.prl_information1) org_id
1892: , REPLACE(hou1.name,l_seperator,' ') employer_name
1893: FROM per_all_people_f papf
1894: ,per_all_assignments_f paa
1895: ,per_periods_of_service pps
1896: ,pay_payroll_actions ppa
1897: ,pay_assignment_actions asg_act
1898: ,pay_all_payrolls_f ppf