APPS.PAY_IE_P45_ARCHIVE dependencies on PER_TIME_PERIODS

Line 712: from per_time_periods ptp

708: fgf.effective_start_date and fgf.effective_end_date;*/
709:
710: cursor cur_period_type is
711: select ptp.period_type
712: from per_time_periods ptp
713: where time_period_id = p_time_period_id;
714:
715: cursor cur_sep_name_dob(p_bg_id NUMBER) is
716: select papf.date_of_birth,papf.first_name, papf.last_name

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

808: -- Added by vikas cursor to number_per_fiscal_year.
809: -- Since tax credit and cutoff figures are fetched from run-results, for
810: -- bi-weekly payroll cutoff and credit and are shown as twice of weekly figures.
811: -- bug 5510536
812: cursor csr_number_per_year (l_period_type per_time_periods.period_type%type) is
813: select number_per_fiscal_year
814: from per_time_period_types tpt
815: where period_type = l_period_type;
816: --

Line 1285: , per_time_periods PPTP

1281: , pay_assignment_actions ASSACT
1282: , pay_assignment_actions BAL_ASSACT
1283: , pay_payroll_actions PACT
1284: , pay_payroll_actions BACT
1285: , per_time_periods PPTP
1286: , per_time_periods BPTP
1287: , pay_run_results PROCESS_RR
1288: , pay_run_result_values PROCESS
1289: , pay_input_values_f PROCESS_IV

Line 1286: , per_time_periods BPTP

1282: , pay_assignment_actions BAL_ASSACT
1283: , pay_payroll_actions PACT
1284: , pay_payroll_actions BACT
1285: , per_time_periods PPTP
1286: , per_time_periods BPTP
1287: , pay_run_results PROCESS_RR
1288: , pay_run_result_values PROCESS
1289: , pay_input_values_f PROCESS_IV
1290: , pay_action_contexts ACX_PROCESS_ID

Line 2208: per_time_periods ptp,

2204: ptpr.periods_per_period,
2205: ptp.start_date,
2206: ptp.end_date
2207: from per_all_assignments_f paf,
2208: per_time_periods ptp,
2209: per_time_period_types ptpt,
2210: per_time_period_rules ptpr
2211: where paf.assignment_id = p_assignment_id
2212: and p_date_earned between paf.effective_start_date

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

3170: pay_payroll_actions paa,
3171: pay_payroll_actions ppaa,
3172: pay_assignment_actions assact,
3173: pay_assignment_actions passact,
3174: per_time_periods ptp -- Added to retrieve correct time_period_id 4906850
3175: WHERE pre.locked_action_id = pay.locking_action_id
3176: AND pre.locking_action_id = p_locking_action_id
3177: AND pre.locked_action_id = passact.assignment_action_id
3178: AND passact.payroll_action_id = ppaa.payroll_action_id

Line 3668: ,per_time_periods ptp

3664: ,pay_action_information pai_epif
3665: ,pay_assignment_actions paa
3666: ,pay_action_interlocks pai_arc
3667: ,pay_assignment_actions paa_payroll
3668: ,per_time_periods ptp
3669: ,pay_ie_p45_address_details emp_address
3670: ,pay_ie_p45_employee_details emp_details
3671: ,pay_ie_p45_soc_ben_details emp_soc
3672: ,pay_ie_p45_prsi_details emp_prsi

Line 3714: ,per_time_periods ptp

3710: to_date(substr(pai_iep45.action_information7, 1,30),'DD/MM/RRRR') date_paid --Bug 3991416
3711: FROM pay_action_information pai_ed
3712: ,pay_action_information pai_iep45
3713: ,pay_assignment_actions paa
3714: ,per_time_periods ptp
3715: WHERE paa.payroll_action_id = c_p45_arch_id
3716: AND paa.assignment_action_id = pai_iep45.action_context_id
3717: AND pai_iep45.action_context_type ='AAP'
3718: AND pai_iep45.action_information_category = 'IE P45 INFORMATION'