APPS.PAY_IE_P45_ARCHIVE dependencies on PER_TIME_PERIODS

Line 912: from per_time_periods ptp

908: fgf.effective_start_date and fgf.effective_end_date;*/
909:
910: cursor cur_period_type is
911: select ptp.period_type
912: from per_time_periods ptp
913: where time_period_id = p_time_period_id;
914:
915: cursor cur_sep_name_dob(p_bg_id NUMBER) is
916: select papf.date_of_birth,papf.first_name, papf.last_name

Line 1025: cursor csr_number_per_year (l_period_type per_time_periods.period_type%type) is

1021: -- Added by vikas cursor to number_per_fiscal_year.
1022: -- Since tax credit and cutoff figures are fetched from run-results, for
1023: -- bi-weekly payroll cutoff and credit and are shown as twice of weekly figures.
1024: -- bug 5510536
1025: cursor csr_number_per_year (l_period_type per_time_periods.period_type%type) is
1026: select number_per_fiscal_year
1027: from per_time_period_types tpt
1028: where period_type = l_period_type;
1029: --

Line 1549: , per_time_periods PPTP

1545: , pay_assignment_actions ASSACT
1546: , pay_assignment_actions BAL_ASSACT
1547: , pay_payroll_actions PACT
1548: , pay_payroll_actions BACT
1549: , per_time_periods PPTP
1550: , per_time_periods BPTP
1551: , pay_run_results PROCESS_RR
1552: , pay_run_result_values PROCESS
1553: , pay_input_values_f PROCESS_IV

Line 1550: , per_time_periods BPTP

1546: , pay_assignment_actions BAL_ASSACT
1547: , pay_payroll_actions PACT
1548: , pay_payroll_actions BACT
1549: , per_time_periods PPTP
1550: , per_time_periods BPTP
1551: , pay_run_results PROCESS_RR
1552: , pay_run_result_values PROCESS
1553: , pay_input_values_f PROCESS_IV
1554: , pay_action_contexts ACX_PROCESS_ID

Line 2875: per_time_periods ptp,

2871: ptpr.periods_per_period,
2872: ptp.start_date,
2873: ptp.end_date
2874: from per_all_assignments_f paf,
2875: per_time_periods ptp,
2876: per_time_period_types ptpt,
2877: per_time_period_rules ptpr
2878: where paf.assignment_id = p_assignment_id
2879: and p_date_earned between paf.effective_start_date

Line 3943: per_time_periods ptp -- Added to retrieve correct time_period_id 4906850

3939: pay_payroll_actions paa,
3940: pay_payroll_actions ppaa,
3941: pay_assignment_actions assact,
3942: pay_assignment_actions passact,
3943: per_time_periods ptp -- Added to retrieve correct time_period_id 4906850
3944: WHERE pre.locked_action_id = pay.locking_action_id
3945: AND pre.locking_action_id = p_locking_action_id
3946: AND pre.locked_action_id = passact.assignment_action_id
3947: AND passact.payroll_action_id = ppaa.payroll_action_id

Line 4591: ,per_time_periods ptp

4587: ,pay_action_information pai_epif
4588: ,pay_assignment_actions paa
4589: ,pay_action_interlocks pai_arc
4590: ,pay_assignment_actions paa_payroll
4591: ,per_time_periods ptp
4592: ,pay_ie_p45_address_details emp_address
4593: ,pay_ie_p45_employee_details emp_details
4594: ,pay_ie_p45_soc_ben_details emp_soc
4595: ,pay_ie_p45_prsi_details emp_prsi

Line 4639: ,per_time_periods ptp

4635: ,pai_iep45.action_information9 main_p45_date_paid -- 7291676
4636: FROM pay_action_information pai_ed
4637: ,pay_action_information pai_iep45
4638: ,pay_assignment_actions paa
4639: ,per_time_periods ptp
4640: WHERE paa.payroll_action_id = c_p45_arch_id
4641: AND paa.assignment_action_id = pai_iep45.action_context_id
4642: AND pai_iep45.action_context_type ='AAP'
4643: AND pai_iep45.action_information_category = 'IE P45 INFORMATION'