APPS.PAY_IE_P35 dependencies on HR_SOFT_CODING_KEYFLEX

Line 31: l_segment4 hr_soft_coding_keyflex.segment4%TYPE;

27: l_context_value_counter NUMBER (2) := 0;
28: l_start_date DATE;
29: l_end_date DATE;
30: l_bg_id NUMBER;
31: l_segment4 hr_soft_coding_keyflex.segment4%TYPE;
32: l_assignment_set_id hr_assignment_sets.assignment_set_id%TYPE;
33: l_payroll_id pay_all_payrolls_f.payroll_id%TYPE;
34:
35:

Line 211: p_segment4 hr_soft_coding_keyflex.segment4%TYPE,

207: --------------------------------------------------------------------------------
208: PROCEDURE get_p60_prsi_details(p_assignment_action_id number,
209: p_max_action_id number,
210: p_person_id number,
211: p_segment4 hr_soft_coding_keyflex.segment4%TYPE,
212: p_tot_insurable_weeks number,
213: p_prsi_employee_cont number,
214: p_prsi_tot_cont number,
215: p_insurable_weeks out nocopy varchar2,

Line 813: hr_soft_coding_keyflex flex

809: pay_assignment_actions paa,
810: pay_payroll_actions ppa,
811: pay_all_payrolls_f pap,
812: per_time_periods ptp,
813: hr_soft_coding_keyflex flex
814: WHERE paa.source_action_id IS NULL
815: AND paa.payroll_action_id = ppa.payroll_action_id
816: --Added for date track updates of payroll with diff pay ref no
817: AND ppa.payroll_id = pap.payroll_id

Line 842: ,hr_soft_coding_keyflex flex1

838: pay_assignment_actions paa1, --Bug fix 4130665
839: pay_payroll_actions ppa1,
840: per_time_periods ptp1 --Tar 15081088.6
841: ,pay_all_payrolls_f pay
842: ,hr_soft_coding_keyflex flex1
843: WHERE paf.person_id = asg.person_id
844: -- AND paf.primary_flag = 'Y'
845: --Added for bug fix 4130665
846: AND paf.assignment_id = paa1.assignment_id

Line 890: -- , hr_soft_coding_keyflex hflex

886: FROM hr_assignment_set_amendments hasa
887: , hr_assignment_sets has
888: , per_assignments_f paf
889: -- , pay_all_payrolls_f pay
890: -- , hr_soft_coding_keyflex hflex
891: WHERE has.assignment_set_id = hasa.assignment_set_id
892: AND has.business_group_id = l_bg_id
893: AND has.assignment_set_id = l_assignment_set_id
894: AND hasa.assignment_id = paf.assignment_id

Line 904: -- , hr_soft_coding_keyflex hflex

900: FROM hr_assignment_set_amendments hasa
901: , hr_assignment_sets has
902: , per_assignments_f paf
903: -- , pay_all_payrolls_f pay
904: -- , hr_soft_coding_keyflex hflex
905: WHERE has.assignment_set_id = hasa.assignment_set_id
906: AND has.business_group_id = l_bg_id
907: AND has.assignment_set_id = l_assignment_set_id
908: AND hasa.assignment_id = paf.assignment_id

Line 921: hr_soft_coding_keyflex flex_p35,

917: FROM pay_assignment_actions paa_p35,
918: pay_payroll_actions ppa_p35,
919: per_assignments_f paaf_p35,
920: pay_all_payrolls_f ppf_p35,
921: hr_soft_coding_keyflex flex_p35,
922: pay_action_interlocks plock
923: WHERE ppa_p35.report_type = 'IEP35'
924: AND paa_p35.action_status = 'C'
925: AND TO_CHAR ( TO_DATE (

Line 1427: l_segment4 hr_soft_coding_keyflex.segment4%TYPE;

1423: l_effective_date DATE;
1424: l_arch_ppsn pay_action_information.action_information4%TYPE;
1425: l_arch_works_number pay_action_information.action_information14%TYPE
1426: DEFAULT ' '; --BUG 3306202 Added default value
1427: l_segment4 hr_soft_coding_keyflex.segment4%TYPE;
1428: l_arch_person_id per_assignments_f.person_id%TYPE;
1429: l_arch_assignment_id pay_assignment_actions.assignment_id%TYPE;
1430: l_arch_assmt_action_id_bal pay_assignment_actions.assignment_action_id%TYPE;
1431: l_arch_tax_deduction_basis pay_action_information.action_information17%TYPE;

Line 2404: ,hr_soft_coding_keyflex flex

2400: SELECT max(pps.period_of_service_id)
2401: FROM per_periods_of_service pps
2402: ,per_assignments_f asg
2403: ,pay_all_payrolls_f pay
2404: ,hr_soft_coding_keyflex flex
2405: WHERE pps.person_id = v_person_id
2406: AND pps.person_id = asg.person_id
2407: AND asg.period_of_service_id <> pps.period_of_service_id
2408: AND asg.assignment_id = v_assignment_id