APPS.PAY_ZA_TYE_ARCHIVE_PKG dependencies on PER_TIME_PERIODS

Line 779: , per_time_periods ptp

775: /* the ordered hint will force the paa table to be joined to first */
776: NULL
777: FROM pay_assignment_actions paa
778: , pay_payroll_actions ppa
779: , per_time_periods ptp
780: WHERE paa.assignment_id = asg.assignment_id
781: AND paa.payroll_action_id = ppa.payroll_action_id
782: AND ppa.action_type IN ('R', 'Q', 'V', 'B', 'I')
783: AND ptp.time_period_id = ppa.time_period_id

Line 1044: , per_time_periods ptp

1040:
1041: cursor curdirnum (p_ass_id in number, p_tax_year varchar2, p_period_recon_last_date date, p_period_recon varchar2) is
1042: select distinct prrv.result_value directive_number
1043: from pay_payroll_actions ppa
1044: , per_time_periods ptp
1045: , pay_assignment_actions paa
1046: , pay_run_results prr
1047: , pay_run_result_values prrv
1048: , pay_element_types_f peef

Line 1321: per_time_periods ptp

1317: select max(paa.action_sequence)
1318: into l_run_action_seq
1319: from pay_assignment_actions paa,
1320: pay_payroll_actions ppa,
1321: per_time_periods ptp
1322: where paa.assignment_id = l_assignment_id
1323: and paa.action_status IN ('C','S') --10376999
1324: and paa.payroll_action_id = ppa.payroll_action_id
1325: and ppa.action_type IN ('R', 'Q', 'V', 'B', 'I')

Line 2808: , per_time_periods ptp

2804: select max(paa.action_sequence)
2805: into l_max_act_seq
2806: from pay_assignment_actions paa
2807: , pay_payroll_actions ppa
2808: , per_time_periods ptp
2809: where paa.assignment_id = l_assignment_id
2810: and paa.payroll_action_id = ppa.payroll_action_id
2811: and ppa.action_type in ('R', 'Q', 'V', 'B', 'I')
2812: and ptp.time_period_id = ppa.time_period_id

Line 2822: , per_time_periods ptp

2818: select ppa.payroll_id, paa.assignment_action_id, ptp.start_date
2819: into l_payroll_id, l_run_assact_id, p_lumpsum_date
2820: from pay_payroll_actions ppa
2821: , pay_assignment_actions paa
2822: , per_time_periods ptp
2823: where paa.assignment_id = l_assignment_id
2824: and paa.action_sequence = l_max_act_seq
2825: and ppa.payroll_action_id = paa.payroll_action_id
2826: and ptp.time_period_id = ppa.time_period_id ;

Line 2834: from per_time_periods

2830: -- 9877034 starts
2831: if l_period_recon = '02' then
2832: select min(start_date), max(end_date)
2833: into l_tax_year_start_date, l_tax_year_end_date
2834: from per_time_periods
2835: where payroll_id = l_payroll_id
2836: and prd_information1 = l_tax_year;
2837:
2838: select count(start_date)

Line 2840: from per_time_periods

2836: and prd_information1 = l_tax_year;
2837:
2838: select count(start_date)
2839: into l_total_tax_periods
2840: from per_time_periods
2841: where payroll_id = l_payroll_id
2842: and prd_information1 = l_tax_year;
2843: else
2844: select min(start_date), max(end_date)

Line 2846: from per_time_periods

2842: and prd_information1 = l_tax_year;
2843: else
2844: select min(start_date), max(end_date)
2845: into l_tax_year_start_date, l_tax_year_end_date
2846: from per_time_periods
2847: where payroll_id = l_payroll_id
2848: and prd_information1 = l_tax_year
2849: and end_date <= l_period_recon_last_date;
2850:

Line 2853: from per_time_periods

2849: and end_date <= l_period_recon_last_date;
2850:
2851: select count(start_date)
2852: into l_total_tax_periods
2853: from per_time_periods
2854: where payroll_id = l_payroll_id
2855: and prd_information1 = l_tax_year
2856: and end_date <= l_period_recon_last_date;
2857: end if;