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 204: p_segment4 hr_soft_coding_keyflex.segment4%TYPE,

200: --------------------------------------------------------------------------------
201: PROCEDURE get_p60_prsi_details(p_assignment_action_id number,
202: p_max_action_id number,
203: p_person_id number,
204: p_segment4 hr_soft_coding_keyflex.segment4%TYPE,
205: p_tot_insurable_weeks number,
206: p_prsi_employee_cont number,
207: p_prsi_tot_cont number,
208: p_insurable_weeks out nocopy varchar2,

Line 805: hr_soft_coding_keyflex flex

801: pay_assignment_actions paa,
802: pay_payroll_actions ppa,
803: pay_all_payrolls_f pap,
804: per_time_periods ptp,
805: hr_soft_coding_keyflex flex
806: WHERE paa.source_action_id IS NULL
807: AND paa.payroll_action_id = ppa.payroll_action_id
808: --Added for date track updates of payroll with diff pay ref no
809: AND ppa.payroll_id = pap.payroll_id

Line 834: ,hr_soft_coding_keyflex flex1

830: pay_assignment_actions paa1, --Bug fix 4130665
831: pay_payroll_actions ppa1,
832: per_time_periods ptp1 --Tar 15081088.6
833: ,pay_all_payrolls_f pay
834: ,hr_soft_coding_keyflex flex1
835: WHERE paf.person_id = asg.person_id
836: -- AND paf.primary_flag = 'Y'
837: --Added for bug fix 4130665
838: AND paf.assignment_id = paa1.assignment_id

Line 882: -- , hr_soft_coding_keyflex hflex

878: FROM hr_assignment_set_amendments hasa
879: , hr_assignment_sets has
880: , per_assignments_f paf
881: -- , pay_all_payrolls_f pay
882: -- , hr_soft_coding_keyflex hflex
883: WHERE has.assignment_set_id = hasa.assignment_set_id
884: AND has.business_group_id = l_bg_id
885: AND has.assignment_set_id = l_assignment_set_id
886: AND hasa.assignment_id = paf.assignment_id

Line 896: -- , hr_soft_coding_keyflex hflex

892: FROM hr_assignment_set_amendments hasa
893: , hr_assignment_sets has
894: , per_assignments_f paf
895: -- , pay_all_payrolls_f pay
896: -- , hr_soft_coding_keyflex hflex
897: WHERE has.assignment_set_id = hasa.assignment_set_id
898: AND has.business_group_id = l_bg_id
899: AND has.assignment_set_id = l_assignment_set_id
900: AND hasa.assignment_id = paf.assignment_id

Line 913: hr_soft_coding_keyflex flex_p35,

909: FROM pay_assignment_actions paa_p35,
910: pay_payroll_actions ppa_p35,
911: per_assignments_f paaf_p35,
912: pay_all_payrolls_f ppf_p35,
913: hr_soft_coding_keyflex flex_p35,
914: pay_action_interlocks plock
915: WHERE ppa_p35.report_type = 'IEP35'
916: AND paa_p35.action_status = 'C'
917: AND TO_CHAR ( TO_DATE (

Line 1170: l_segment4 hr_soft_coding_keyflex.segment4%TYPE;

1166: l_effective_date DATE;
1167: l_arch_ppsn pay_action_information.action_information4%TYPE;
1168: l_arch_works_number pay_action_information.action_information14%TYPE
1169: DEFAULT ' '; --BUG 3306202 Added default value
1170: l_segment4 hr_soft_coding_keyflex.segment4%TYPE;
1171: l_arch_person_id per_assignments_f.person_id%TYPE;
1172: l_arch_assignment_id pay_assignment_actions.assignment_id%TYPE;
1173: l_arch_assmt_action_id_bal pay_assignment_actions.assignment_action_id%TYPE;
1174: l_arch_tax_deduction_basis pay_action_information.action_information17%TYPE;

Line 1989: ,hr_soft_coding_keyflex flex

1985: SELECT max(pps.period_of_service_id)
1986: FROM per_periods_of_service pps
1987: ,per_assignments_f asg
1988: ,pay_all_payrolls_f pay
1989: ,hr_soft_coding_keyflex flex
1990: WHERE pps.person_id = v_person_id
1991: AND pps.person_id = asg.person_id
1992: AND asg.period_of_service_id <> pps.period_of_service_id
1993: AND asg.assignment_id = v_assignment_id