eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_AU_PAYMENT_SUMMARY dependencies on PAY_PAYROLL_ACTIONS

Line 277: (p_payroll_action_id in pay_payroll_actions.payroll_action_id%type,

273: -- of assignments eligible for archival.
274: --------------------------------------------------------------------+
275:
276: procedure range_code
277: (p_payroll_action_id in pay_payroll_actions.payroll_action_id%type,
278: p_sql out nocopy varchar2) is
279: begin
280: g_debug := hr_utility.debug_enabled;
281: IF g_debug THEN

Line 287: ' pay_payroll_actions pa' ||

283: END if;
284: /* Bug#3043049*/
285: p_sql := ' select distinct p.person_id' ||
286: ' from per_people_f p,' ||
287: ' pay_payroll_actions pa' ||
288: ' where pa.payroll_action_id = :payroll_action_id' ||
289: ' and p.business_group_id = pa.business_group_id' ||
290: ' order by p.person_id';
291: IF g_debug THEN

Line 304: procedure initialization_code (p_payroll_action_id in pay_payroll_actions.payroll_action_id%type) is

300: -- procedure is not present then archiver assumes that no archival is required.
301: --------------------------------------------------------------------+
302:
303:
304: procedure initialization_code (p_payroll_action_id in pay_payroll_actions.payroll_action_id%type) is
305: --
306: --------------------------------------------------------------------------------------+
307: -- Cursor to setup table to hold balance_id's to be retrieved using BBR. (Bug3172963)
308: --------------------------------------------------------------------------------------+

Line 430: FROM pay_payroll_actions ppa

426: CURSOR get_params(c_payroll_action_id per_all_assignments_f.assignment_id%type)
427: IS
428: SELECT to_date('30-06-'||substr(pay_core_utils.get_parameter('FINANCIAL_YEAR',legislative_parameters),6,4),'DD-MM-YYYY') Financial_year_end
429: ,ppa.business_group_id
430: FROM pay_payroll_actions ppa
431: WHERE ppa.payroll_action_id = c_payroll_Action_id;
432:
433: l_fin_year_date DATE;
434:

Line 638: (p_payroll_action_id in pay_payroll_actions.payroll_action_id%type,

634: -- component of more than $1000 for that FBT year
635: -- and have been terminated during the FBT year
636:
637: procedure assignment_action_code
638: (p_payroll_action_id in pay_payroll_actions.payroll_action_id%type,
639: p_start_person_id in per_all_people_f.person_id%type,
640: p_end_person_id in per_all_people_f.person_id%type,
641: p_chunk in number) is
642:

Line 678: from pay_payroll_actions

674: pay_core_utils.get_parameter('ASSIGNMENT_ID',legislative_parameters)) Assignment_id
675: ,decode(pay_core_utils.get_parameter('PAYROLL',legislative_parameters),null,'%',pay_core_utils.get_parameter('PAYROLL',legislative_parameters)) payroll_id
676: ,pay_core_utils.get_parameter('LST_YR_TERM',legislative_parameters) lst_yr_term /*3661230*/
677: ,pay_core_utils.get_parameter('BUSINESS_GROUP_ID',legislative_parameters) Business_group_id
678: from pay_payroll_actions
679: where payroll_action_id = c_payroll_Action_id;
680:
681: ----------------------------------------------+
682: -- cursor to restrict assignment ids

Line 686: Cursor process_assignments(c_payroll_action_id in pay_payroll_actions.payroll_action_id%type,

682: -- cursor to restrict assignment ids
683: ----------------------------------------------+
684: /* 4926521 Modified adn put group by in 2 sub queries for performacne */
685: /* 5099419 Removed fix for bug 4926521 */
686: Cursor process_assignments(c_payroll_action_id in pay_payroll_actions.payroll_action_id%type,
687: c_start_person_id in per_all_people_f.person_id%type,
688: c_end_person_id in per_all_people_f.person_id%type)
689: is
690: select /*+ INDEX(p per_people_f_pk)

Line 693: INDEX(pa pay_payroll_actions_pk)

689: is
690: select /*+ INDEX(p per_people_f_pk)
691: INDEX(a per_assignments_f_fk1)
692: INDEX(a per_assignments_f_N12)
693: INDEX(pa pay_payroll_actions_pk)
694: INDEX(pps per_periods_of_service_n3)
695: */ distinct a.assignment_id
696: from per_people_f p /*Bug3043049*/
697: ,per_assignments_f a /*Bug3043049*/

Line 698: ,pay_payroll_actions pa

694: INDEX(pps per_periods_of_service_n3)
695: */ distinct a.assignment_id
696: from per_people_f p /*Bug3043049*/
697: ,per_assignments_f a /*Bug3043049*/
698: ,pay_payroll_actions pa
699: ,per_periods_of_service pps
700: where pa.payroll_action_id = c_payroll_action_id
701: and p.person_id between c_start_person_id and c_end_person_id
702: and p.person_id = a.person_id

Line 720: INDEX(rppa PAY_PAYROLL_ACTIONS_N51*/ ''

716: AND iipaf.payroll_id IS NOT NULL) /*Bug# 4653934*/
717: and a.payroll_id like v_payroll_id -- Bug 3815301
718: and exists
719: (select /*+ INDEX(rpac PAY_ASSIGNMENT_ACTIONS_N51)
720: INDEX(rppa PAY_PAYROLL_ACTIONS_N51*/ ''
721: from
722: pay_payroll_actions rppa
723: ,pay_assignment_actions rpac /*Bug3048962 */
724: ,per_assignments_f paaf /*Bug 3815301 */

Line 722: pay_payroll_actions rppa

718: and exists
719: (select /*+ INDEX(rpac PAY_ASSIGNMENT_ACTIONS_N51)
720: INDEX(rppa PAY_PAYROLL_ACTIONS_N51*/ ''
721: from
722: pay_payroll_actions rppa
723: ,pay_assignment_actions rpac /*Bug3048962 */
724: ,per_assignments_f paaf /*Bug 3815301 */
725: where ( rppa.effective_date between v_fin_year_start and v_fin_year_end
726: or ( pps.actual_termination_date between v_lst_fbt_year_start and v_fbt_year_end /*Bug3263659 */ --Bug#3661230

Line 744: pay_payroll_actions paas

740: and not exists
741: (select distinct paat.assignment_id
742: from pay_action_interlocks pail,
743: pay_assignment_actions paat,
744: pay_payroll_actions paas
745: where paat.assignment_id = a.assignment_id
746: and paas.action_type ='X'
747: and paas.action_status ='C'
748: and paas.report_type ='AU_PAYMENT_SUMMARY_REPORT'

Line 773: Cursor process_assignments_only(c_payroll_action_id in pay_payroll_actions.payroll_action_id%type,

769:
770: /* Cursor added for bug3019374 -- Processed when a single assignment is entered*/
771:
772:
773: Cursor process_assignments_only(c_payroll_action_id in pay_payroll_actions.payroll_action_id%type,
774: c_start_person_id in per_all_people_f.person_id%type,
775: c_end_person_id in per_all_people_f.person_id%type)
776: is
777: select distinct a.assignment_id

Line 780: ,pay_payroll_actions pa

776: is
777: select distinct a.assignment_id
778: from per_people_f p /*Bug3043049*/
779: ,per_assignments_f a /*Bug3043049*/
780: ,pay_payroll_actions pa
781: ,per_periods_of_service pps
782: where pa.payroll_action_id = c_payroll_action_id
783: and p.person_id between c_start_person_id and c_end_person_id
784: and p.person_id = a.person_id

Line 802: INDEX(rppa PAY_PAYROLL_ACTIONS_N51 */ ''

798: AND iipaf.payroll_id IS NOT NULL) /*Bug# 4653934*/
799: and a.payroll_id like v_payroll_id -- Bug 3815301
800: and exists
801: (select /*+ INDEX(rpac PAY_ASSIGNMENT_ACTIONS_N51)
802: INDEX(rppa PAY_PAYROLL_ACTIONS_N51 */ ''
803: from pay_payroll_actions rppa
804: ,pay_assignment_actions rpac/*Bug3048962 */
805: ,per_assignments_f paaf /*Bug 3815301 */
806: where ( rppa.effective_date between v_fin_year_start and v_fin_year_end

Line 803: from pay_payroll_actions rppa

799: and a.payroll_id like v_payroll_id -- Bug 3815301
800: and exists
801: (select /*+ INDEX(rpac PAY_ASSIGNMENT_ACTIONS_N51)
802: INDEX(rppa PAY_PAYROLL_ACTIONS_N51 */ ''
803: from pay_payroll_actions rppa
804: ,pay_assignment_actions rpac/*Bug3048962 */
805: ,per_assignments_f paaf /*Bug 3815301 */
806: where ( rppa.effective_date between v_fin_year_start and v_fin_year_end
807: or ( pps.actual_termination_date between v_lst_fbt_year_start and v_fbt_year_end /*Bug3263659 */ --Bug#3661230

Line 825: pay_payroll_actions paas

821: and not exists
822: (select distinct paat.assignment_id
823: from pay_action_interlocks pail,
824: pay_assignment_actions paat,
825: pay_payroll_actions paas
826: where paat.assignment_id = a.assignment_id
827: and paas.action_type ='X'
828: and paas.action_status ='C'
829: and paas.report_type ='AU_PAYMENT_SUMMARY_REPORT'

Line 863: CURSOR range_process_assignments(c_payroll_action_id IN pay_payroll_actions.payroll_action_id%TYPE,

859: -- Used when RANGE_PERSON_ID feature is enabled
860: --------------------------------------------------------------------+
861: */
862:
863: CURSOR range_process_assignments(c_payroll_action_id IN pay_payroll_actions.payroll_action_id%TYPE,
864: c_chunk IN NUMBER)
865: IS
866: SELECT /*+ INDEX(pap per_people_f_pk)
867: INDEX(rppa pay_payroll_actions_pk)

Line 867: INDEX(rppa pay_payroll_actions_pk)

863: CURSOR range_process_assignments(c_payroll_action_id IN pay_payroll_actions.payroll_action_id%TYPE,
864: c_chunk IN NUMBER)
865: IS
866: SELECT /*+ INDEX(pap per_people_f_pk)
867: INDEX(rppa pay_payroll_actions_pk)
868: INDEX(ppr PAY_POPULATION_RANGES_N4)
869: INDEX(paa per_assignments_f_N12)
870: INDEX(pps per_periods_of_service_PK)
871: */ a.assignment_id

Line 874: ,pay_payroll_actions pa

870: INDEX(pps per_periods_of_service_PK)
871: */ a.assignment_id
872: FROM per_people_f p /*Bug3043049*/
873: ,per_assignments_f a /*Bug3043049*/
874: ,pay_payroll_actions pa
875: ,per_periods_of_service pps
876: ,pay_population_ranges ppr
877: WHERE pa.payroll_action_id = c_payroll_action_id
878: AND pa.payroll_action_id = ppr.payroll_action_id

Line 898: INDEX(rppa PAY_PAYROLL_ACTIONS_N51*/ ''

894: AND iipaf.payroll_id IS NOT NULL) /*Bug# 4653934*/
895: AND a.payroll_id LIKE v_payroll_id -- Bug 3815301
896: AND EXISTS
897: (SELECT /*+ INDEX(rpac PAY_ASSIGNMENT_ACTIONS_N51)
898: INDEX(rppa PAY_PAYROLL_ACTIONS_N51*/ ''
899: FROM
900: pay_payroll_actions rppa
901: ,pay_assignment_actions rpac /*Bug3048962 */
902: ,per_assignments_f paaf /*Bug 3815301 */

Line 900: pay_payroll_actions rppa

896: AND EXISTS
897: (SELECT /*+ INDEX(rpac PAY_ASSIGNMENT_ACTIONS_N51)
898: INDEX(rppa PAY_PAYROLL_ACTIONS_N51*/ ''
899: FROM
900: pay_payroll_actions rppa
901: ,pay_assignment_actions rpac /*Bug3048962 */
902: ,per_assignments_f paaf /*Bug 3815301 */
903: WHERE ( rppa.effective_date BETWEEN v_fin_year_start AND v_fin_year_end
904: OR ( pps.actual_termination_date BETWEEN v_lst_fbt_year_start AND v_fbt_year_end /*Bug3263659 */ --Bug#3661230

Line 923: pay_payroll_actions paas

919: AND NOT EXISTS
920: (SELECT paat.assignment_id
921: FROM pay_action_interlocks pail,
922: pay_assignment_actions paat,
923: pay_payroll_actions paas
924: WHERE paat.assignment_id = a.assignment_id
925: AND paas.action_type ='X'
926: AND paas.action_status ='C'
927: AND paas.report_type ='AU_PAYMENT_SUMMARY_REPORT'

Line 1330: ,p_payroll_action_id in pay_payroll_actions.payroll_action_id%TYPE

1326: ,p_legislation_code in pay_defined_balances.legislation_code%TYPE
1327: ,p_year_start in DATE
1328: ,p_year_end in DATE
1329: ,p_assignment_id in pay_assignment_actions.ASSIGNMENT_ID%type
1330: ,p_payroll_action_id in pay_payroll_actions.payroll_action_id%TYPE
1331: ,p_bal_value OUT NOCOPY varchar2) IS -- Bug 3098353
1332:
1333: v_bal_value varchar2(20);
1334: v_earnings_ytd varchar2(20);

Line 1418: pay_payroll_Actions ppa,

1414: IS
1415: select /*+ USE_NL(ptp) */ -- Bug 4925650
1416: max(paa.assignment_action_id) -- Bug: 3095919, Bug 2610141
1417: from per_assignments_f paf,
1418: pay_payroll_Actions ppa,
1419: pay_assignment_Actions paa,
1420: per_time_periods ptp
1421: where ppa.payroll_Action_id = paa.payroll_Action_id
1422: and paa.assignment_id = c_assignment_id

Line 1748: ,pay_payroll_actions ppa

1744: pac.tax_unit_id /* Added for bug #5846278 */
1745: FROM per_all_assignments_f paa
1746: ,per_periods_of_service pps
1747: ,pay_assignment_actions pac
1748: ,pay_payroll_actions ppa
1749: ,pay_element_entries_f pee
1750: ,pay_run_results prr
1751: ,pay_element_types_f pet
1752: ,pay_balance_types pbt

Line 2077: , pay_payroll_actions ppa

2073: , pay_balance_types pbt
2074: , pay_defined_balances pdb
2075: --, pay_balance_dimensions pbd
2076: --, per_periods_of_service pps
2077: , pay_payroll_actions ppa
2078: , pay_assignment_actions pac
2079: , pay_run_results prr
2080: where pac.assignment_id = c_assignment_id
2081: and pac.tax_unit_id = p_registered_employer --2610141

Line 2268: ,pay_payroll_actions ppa

2264: ,per_all_assignments_f paa
2265: ,pay_run_results prr
2266: ,pay_run_result_values prv
2267: ,pay_assignment_actions pac
2268: ,pay_payroll_actions ppa
2269: ,pay_payrolls_f papf /* bug Number 4278361 */
2270: where pet.element_type_id = piv.element_type_id
2271: and pet.element_name = 'ETP on Termination'
2272: and piv.name = 'Pay ETP Components'

Line 2296: c_payroll_action_id pay_payroll_actions.payroll_action_id%type,

2292: and pac.tax_unit_id = p_registered_employer; --2610141
2293:
2294: cursor etp_prepayment
2295: (c_assignment_action_id pay_assignment_actions.assignment_action_id%type,
2296: c_payroll_action_id pay_payroll_actions.payroll_action_id%type,
2297: c_year_start date,
2298: c_year_end date )
2299: is select to_char(pppa.effective_date,'DDMMYYYY')
2300: from pay_action_interlocks pai

Line 2302: ,pay_payroll_actions ppa

2298: c_year_end date )
2299: is select to_char(pppa.effective_date,'DDMMYYYY')
2300: from pay_action_interlocks pai
2301: ,pay_assignment_actions pac
2302: ,pay_payroll_actions ppa
2303: ,pay_assignment_actions ppac
2304: ,pay_payroll_actions pppa
2305: where pac.payroll_action_id = ppa.payroll_action_id
2306: and pac.assignment_action_id = c_assignment_action_id

Line 2304: ,pay_payroll_actions pppa

2300: from pay_action_interlocks pai
2301: ,pay_assignment_actions pac
2302: ,pay_payroll_actions ppa
2303: ,pay_assignment_actions ppac
2304: ,pay_payroll_actions pppa
2305: where pac.payroll_action_id = ppa.payroll_action_id
2306: and pac.assignment_action_id = c_assignment_action_id
2307: and pac.assignment_action_id = pai.locked_action_id
2308: and ppa.payroll_action_id = c_payroll_action_id

Line 2328: ,pay_payroll_actions ppa

2324: is select max(ppa.payroll_action_id) payroll_action_id
2325: ,max(pac.assignment_action_id) assignment_action_id
2326: from per_assignments_f paf
2327: ,pay_assignment_actions pac
2328: ,pay_payroll_actions ppa
2329: where pac.assignment_id = c_assignment_id
2330: and pac.tax_unit_id = p_registered_employer --2610141
2331: and paf.assignment_id = pac.assignment_id
2332: and ppa.action_type in ('B','I')

Line 2443: , pay_payroll_actions ppa

2439: from pay_element_types_f pet
2440: , per_all_assignments_f paa
2441: , pay_balance_types pbt
2442: , pay_defined_balances pdb
2443: , pay_payroll_actions ppa
2444: , pay_assignment_actions pac
2445: , pay_run_results prr
2446: , pay_balance_feeds_f pbf
2447: , pay_input_values_f piv

Line 2829: p_payroll_action_id in pay_payroll_actions.payroll_action_id%type,

2825: ----------------------------------------------------------------------+
2826: Procedure archive_etp_details
2827: (p_business_group_id in hr_organization_units.business_group_id%type,
2828: p_registered_employer in hr_organization_units.organization_id%type,
2829: p_payroll_action_id in pay_payroll_actions.payroll_action_id%type,
2830: p_assignment_Action_id in pay_assignment_actions.assignment_action_id%type,
2831: p_assignment_id in pay_assignment_actions.assignment_id%type,
2832: p_year_start in pay_payroll_actions.effective_date%type,
2833: p_year_end in pay_payroll_Actions.effective_date%type,

Line 2832: p_year_start in pay_payroll_actions.effective_date%type,

2828: p_registered_employer in hr_organization_units.organization_id%type,
2829: p_payroll_action_id in pay_payroll_actions.payroll_action_id%type,
2830: p_assignment_Action_id in pay_assignment_actions.assignment_action_id%type,
2831: p_assignment_id in pay_assignment_actions.assignment_id%type,
2832: p_year_start in pay_payroll_actions.effective_date%type,
2833: p_year_end in pay_payroll_Actions.effective_date%type,
2834: p_lst_year_start in pay_payroll_Actions.effective_date%type,/*Bug3661230 Added one extra parameter*/
2835: p_transitional_flag out nocopy varchar2, /*Bug 6192381 Added New Parameters p_transitional_flag and p_part_prev_etp_flag */
2836: p_part_prev_etp_flag out nocopy varchar2) is

Line 2833: p_year_end in pay_payroll_Actions.effective_date%type,

2829: p_payroll_action_id in pay_payroll_actions.payroll_action_id%type,
2830: p_assignment_Action_id in pay_assignment_actions.assignment_action_id%type,
2831: p_assignment_id in pay_assignment_actions.assignment_id%type,
2832: p_year_start in pay_payroll_actions.effective_date%type,
2833: p_year_end in pay_payroll_Actions.effective_date%type,
2834: p_lst_year_start in pay_payroll_Actions.effective_date%type,/*Bug3661230 Added one extra parameter*/
2835: p_transitional_flag out nocopy varchar2, /*Bug 6192381 Added New Parameters p_transitional_flag and p_part_prev_etp_flag */
2836: p_part_prev_etp_flag out nocopy varchar2) is
2837:

Line 2834: p_lst_year_start in pay_payroll_Actions.effective_date%type,/Bug3661230 Added one extra parameter/

2830: p_assignment_Action_id in pay_assignment_actions.assignment_action_id%type,
2831: p_assignment_id in pay_assignment_actions.assignment_id%type,
2832: p_year_start in pay_payroll_actions.effective_date%type,
2833: p_year_end in pay_payroll_Actions.effective_date%type,
2834: p_lst_year_start in pay_payroll_Actions.effective_date%type,/*Bug3661230 Added one extra parameter*/
2835: p_transitional_flag out nocopy varchar2, /*Bug 6192381 Added New Parameters p_transitional_flag and p_part_prev_etp_flag */
2836: p_part_prev_etp_flag out nocopy varchar2) is
2837:
2838:

Line 2864: c_payroll_action_id in pay_payroll_actions.payroll_action_id%type,

2860: -- cursor to fetch terminated employees details
2861: -----------------------------------------------------------------------------------------------+
2862: cursor etp_details( c_business_group_id in hr_organization_units.business_group_id%type,
2863: c_registered_employer in hr_organization_units.organization_id%type,
2864: c_payroll_action_id in pay_payroll_actions.payroll_action_id%type,
2865: c_assignment_id in pay_assignment_actions.assignment_id%type,
2866: c_year_start in pay_payroll_actions.effective_date%type,
2867: c_year_end in pay_payroll_Actions.effective_date%type)
2868: is

Line 2866: c_year_start in pay_payroll_actions.effective_date%type,

2862: cursor etp_details( c_business_group_id in hr_organization_units.business_group_id%type,
2863: c_registered_employer in hr_organization_units.organization_id%type,
2864: c_payroll_action_id in pay_payroll_actions.payroll_action_id%type,
2865: c_assignment_id in pay_assignment_actions.assignment_id%type,
2866: c_year_start in pay_payroll_actions.effective_date%type,
2867: c_year_end in pay_payroll_Actions.effective_date%type)
2868: is
2869: select pev.screen_entry_value tax_file_number
2870: ,pap.last_name employee_last_name

Line 2867: c_year_end in pay_payroll_Actions.effective_date%type)

2863: c_registered_employer in hr_organization_units.organization_id%type,
2864: c_payroll_action_id in pay_payroll_actions.payroll_action_id%type,
2865: c_assignment_id in pay_assignment_actions.assignment_id%type,
2866: c_year_start in pay_payroll_actions.effective_date%type,
2867: c_year_end in pay_payroll_Actions.effective_date%type)
2868: is
2869: select pev.screen_entry_value tax_file_number
2870: ,pap.last_name employee_last_name
2871: ,pap.first_name employee_first_name

Line 2902: pay_payroll_actions ppa,

2898: per_all_people_f pap,
2899: per_addresses pad,
2900: fnd_territories_tl fta,
2901: per_periods_of_service pps,
2902: pay_payroll_actions ppa,
2903: pay_assignment_actions pac,
2904: hr_locations_all hlc /* Bug No : 2263587 */
2905: where hou.business_group_id = c_business_group_id
2906: and hou.organization_id = c_registered_employer

Line 2963: ,pay_payroll_actions ppa

2959: ,per_all_assignments_f paa
2960: ,pay_run_results prr
2961: ,pay_run_result_values prv
2962: ,pay_assignment_actions pac
2963: ,pay_payroll_actions ppa
2964: where pet.element_type_id = piv.element_type_id
2965: and pet.element_name = 'ETP on Termination'
2966: and piv.name in ('Transitional ETP','Part of Previously Paid ETP')
2967: and paa.assignment_id = c_assignment_id

Line 3155: ,p_payroll_action_id in pay_payroll_actions.payroll_action_id%TYPE

3151: ,p_max_assignment_action_id in pay_assignment_actions.ASSIGNMENT_ACTION_ID%TYPE --2610141
3152: ,p_registered_employer in pay_assignment_actions.TAX_UNIT_ID%TYPE --2610141
3153: ,p_legislation_code in pay_defined_balances.legislation_code%TYPE
3154: ,p_assignment_id in pay_assignment_actions.ASSIGNMENT_ID%type
3155: ,p_payroll_action_id in pay_payroll_actions.payroll_action_id%TYPE
3156: ,p_actual_termination_date in per_periods_of_service.actual_termination_date%TYPE
3157: ,p_date_start in per_periods_of_service.date_start%TYPE
3158: ,p_year_start in pay_payroll_actions.effective_date%type
3159: ,p_year_end in pay_payroll_Actions.effective_date%type

Line 3158: ,p_year_start in pay_payroll_actions.effective_date%type

3154: ,p_assignment_id in pay_assignment_actions.ASSIGNMENT_ID%type
3155: ,p_payroll_action_id in pay_payroll_actions.payroll_action_id%TYPE
3156: ,p_actual_termination_date in per_periods_of_service.actual_termination_date%TYPE
3157: ,p_date_start in per_periods_of_service.date_start%TYPE
3158: ,p_year_start in pay_payroll_actions.effective_date%type
3159: ,p_year_end in pay_payroll_Actions.effective_date%type
3160: ,p_transitional_flag in varchar2 /*Bug 6192381 Added New Parameters p_transitional_flag and p_part_prev_etp_flag */
3161: ,p_part_prev_etp_flag in varchar2) is
3162:

Line 3159: ,p_year_end in pay_payroll_Actions.effective_date%type

3155: ,p_payroll_action_id in pay_payroll_actions.payroll_action_id%TYPE
3156: ,p_actual_termination_date in per_periods_of_service.actual_termination_date%TYPE
3157: ,p_date_start in per_periods_of_service.date_start%TYPE
3158: ,p_year_start in pay_payroll_actions.effective_date%type
3159: ,p_year_end in pay_payroll_Actions.effective_date%type
3160: ,p_transitional_flag in varchar2 /*Bug 6192381 Added New Parameters p_transitional_flag and p_part_prev_etp_flag */
3161: ,p_part_prev_etp_flag in varchar2) is
3162:
3163:

Line 3515: p_payroll_action_id in pay_payroll_actions.payroll_action_id%type,

3511: Procedure archive_employer_details
3512: (p_business_group_id in hr_organization_units.business_group_id%type,
3513: p_max_assignment_action_id in pay_assignment_actions.assignment_action_id%TYPE, --2610141
3514: p_registered_employer in hr_organization_units.organization_id%type,
3515: p_payroll_action_id in pay_payroll_actions.payroll_action_id%type,
3516: p_assignment_action_id in pay_assignment_actions.assignment_action_id%type,
3517: p_assignment_id in pay_assignment_actions.assignment_id%type,
3518: p_year_start in pay_payroll_actions.effective_date%type,
3519: p_year_end in pay_payroll_Actions.effective_date%type) is

Line 3518: p_year_start in pay_payroll_actions.effective_date%type,

3514: p_registered_employer in hr_organization_units.organization_id%type,
3515: p_payroll_action_id in pay_payroll_actions.payroll_action_id%type,
3516: p_assignment_action_id in pay_assignment_actions.assignment_action_id%type,
3517: p_assignment_id in pay_assignment_actions.assignment_id%type,
3518: p_year_start in pay_payroll_actions.effective_date%type,
3519: p_year_end in pay_payroll_Actions.effective_date%type) is
3520:
3521:
3522:

Line 3519: p_year_end in pay_payroll_Actions.effective_date%type) is

3515: p_payroll_action_id in pay_payroll_actions.payroll_action_id%type,
3516: p_assignment_action_id in pay_assignment_actions.assignment_action_id%type,
3517: p_assignment_id in pay_assignment_actions.assignment_id%type,
3518: p_year_start in pay_payroll_actions.effective_date%type,
3519: p_year_end in pay_payroll_Actions.effective_date%type) is
3520:
3521:
3522:
3523: l_group_act_no hr_organization_information.org_information1%type;

Line 3739: p_payroll_action_id in pay_payroll_actions.payroll_action_id%type,

3735:
3736: Procedure archive_employee_details
3737: (p_business_group_id in hr_organization_units.business_group_id%type,
3738: p_registered_employer in hr_organization_units.organization_id%type,
3739: p_payroll_action_id in pay_payroll_actions.payroll_action_id%type,
3740: p_assignment_action_id in pay_assignment_actions.assignment_action_id%type,
3741: p_assignment_id in pay_assignment_actions.assignment_id%type,
3742: p_year_start in pay_payroll_actions.effective_date%type,
3743: p_year_end in pay_payroll_Actions.effective_date%type,

Line 3742: p_year_start in pay_payroll_actions.effective_date%type,

3738: p_registered_employer in hr_organization_units.organization_id%type,
3739: p_payroll_action_id in pay_payroll_actions.payroll_action_id%type,
3740: p_assignment_action_id in pay_assignment_actions.assignment_action_id%type,
3741: p_assignment_id in pay_assignment_actions.assignment_id%type,
3742: p_year_start in pay_payroll_actions.effective_date%type,
3743: p_year_end in pay_payroll_Actions.effective_date%type,
3744: p_end_date_flag in varchar2,
3745: p_fbt_year_start IN pay_payroll_Actions.effective_date%type) is /*Bug# 4653934*/
3746:

Line 3743: p_year_end in pay_payroll_Actions.effective_date%type,

3739: p_payroll_action_id in pay_payroll_actions.payroll_action_id%type,
3740: p_assignment_action_id in pay_assignment_actions.assignment_action_id%type,
3741: p_assignment_id in pay_assignment_actions.assignment_id%type,
3742: p_year_start in pay_payroll_actions.effective_date%type,
3743: p_year_end in pay_payroll_Actions.effective_date%type,
3744: p_end_date_flag in varchar2,
3745: p_fbt_year_start IN pay_payroll_Actions.effective_date%type) is /*Bug# 4653934*/
3746:
3747: l_tfn_no pay_element_entry_values_f.screen_entry_value%type;

Line 3745: p_fbt_year_start IN pay_payroll_Actions.effective_date%type) is /Bug# 4653934/

3741: p_assignment_id in pay_assignment_actions.assignment_id%type,
3742: p_year_start in pay_payroll_actions.effective_date%type,
3743: p_year_end in pay_payroll_Actions.effective_date%type,
3744: p_end_date_flag in varchar2,
3745: p_fbt_year_start IN pay_payroll_Actions.effective_date%type) is /*Bug# 4653934*/
3746:
3747: l_tfn_no pay_element_entry_values_f.screen_entry_value%type;
3748: l_first_name per_all_people_f.first_name%type;
3749: l_middle_name per_all_people_f.middle_names%type;

Line 3766: l_date_earned pay_payroll_actions.date_earned%type;

3762: l_emp_no per_all_people_f.employee_number%type;
3763: l_payroll pay_all_payrolls_f.payroll_name%type;
3764: l_emp_type per_all_people_f.current_employee_flag%type;
3765: l_address_date_from date;
3766: l_date_earned pay_payroll_actions.date_earned%type;
3767: l_effective_date date; -- Bug3263659
3768: l_actual_termination_date per_periods_of_service.actual_termination_date%type;
3769: l_final_process_date date; -- Bug3263659
3770: l_fpd_archive VARCHAR2(20); -- Bug3098353

Line 3801: c_date_earned pay_payroll_actions.date_earned%TYPE)

3797: /*Bug3019374 - Cursor employee_details broken up into 2 cursor -> cursor employee_details
3798: and cursor tfn_number*/
3799:
3800: cursor tfn_number(c_assignment_id per_all_assignments.assignment_id%TYPE,
3801: c_date_earned pay_payroll_actions.date_earned%TYPE)
3802: is
3803: select pev.screen_entry_value tfn_no
3804: from
3805: pay_element_types_f pet,

Line 3874: pay_payroll_actions ppa,

3870: per_all_people_f pap,
3871: per_addresses pad,
3872: fnd_territories_tl fta,
3873: per_periods_of_service pps,
3874: pay_payroll_actions ppa,
3875: pay_assignment_actions pac,
3876: pay_payroll_actions ppa1, /* Bug# 2448441 */
3877: pay_assignment_actions pac1 /* Bug# 2448441 */
3878: where hou.business_group_id = p_business_group_id

Line 3876: pay_payroll_actions ppa1, /* Bug# 2448441 */

3872: fnd_territories_tl fta,
3873: per_periods_of_service pps,
3874: pay_payroll_actions ppa,
3875: pay_assignment_actions pac,
3876: pay_payroll_actions ppa1, /* Bug# 2448441 */
3877: pay_assignment_actions pac1 /* Bug# 2448441 */
3878: where hou.business_group_id = p_business_group_id
3879: and hou.organization_id = p_registered_employer
3880: and ppa.action_type = 'X'

Line 3903: from pay_payroll_actions ppa2,

3899: /* Added for Bug# 2448441 */
3900: and paa.assignment_id = pac1.assignment_id
3901: and ppa1.payroll_action_id = pac1.payroll_action_id
3902: and pac1.assignment_action_id = (select to_number(substr(max(lpad(paa2.action_sequence,15,'0')||paa2.assignment_action_id),16)) /*Bug 7242551 */
3903: from pay_payroll_actions ppa2,
3904: pay_assignment_actions paa2
3905: where ppa2.action_type in ('R','Q','B','I') --Bug 2574186
3906: and ppa2.payroll_action_id = paa2.payroll_action_id
3907: and paa2.tax_unit_id = p_registered_employer -- Bug 2610141

Line 4262: p_payroll_action_id in pay_payroll_actions.payroll_action_id%type,

4258: ------------------------------------------------------------------------+
4259: Procedure archive_supplier_details
4260: (p_business_group_id in hr_organization_units.business_group_id%type,
4261: p_registered_employer in hr_organization_units.organization_id%type,
4262: p_payroll_action_id in pay_payroll_actions.payroll_action_id%type,
4263: p_assignment_Action_id in pay_assignment_actions.assignment_action_id%type,
4264: p_assignment_id in pay_assignment_actions.assignment_id%type,
4265: p_year_start in pay_payroll_actions.effective_date%type,
4266: p_year_end in pay_payroll_Actions.effective_date%type) is

Line 4265: p_year_start in pay_payroll_actions.effective_date%type,

4261: p_registered_employer in hr_organization_units.organization_id%type,
4262: p_payroll_action_id in pay_payroll_actions.payroll_action_id%type,
4263: p_assignment_Action_id in pay_assignment_actions.assignment_action_id%type,
4264: p_assignment_id in pay_assignment_actions.assignment_id%type,
4265: p_year_start in pay_payroll_actions.effective_date%type,
4266: p_year_end in pay_payroll_Actions.effective_date%type) is
4267:
4268:
4269: l_report_end_date varchar2(20);

Line 4266: p_year_end in pay_payroll_Actions.effective_date%type) is

4262: p_payroll_action_id in pay_payroll_actions.payroll_action_id%type,
4263: p_assignment_Action_id in pay_assignment_actions.assignment_action_id%type,
4264: p_assignment_id in pay_assignment_actions.assignment_id%type,
4265: p_year_start in pay_payroll_actions.effective_date%type,
4266: p_year_end in pay_payroll_Actions.effective_date%type) is
4267:
4268:
4269: l_report_end_date varchar2(20);
4270: l_supplier_number hr_organization_information.org_information1%type;

Line 4565: l_business_group_id pay_payroll_actions.business_group_id%type ;

4561: ) is
4562: --
4563: l_procedure constant varchar2(80) := g_package || '.archive_code';
4564: l_assignment_id pay_assignment_actions.assignment_id%type;
4565: l_business_group_id pay_payroll_actions.business_group_id%type ;
4566: l_registered_employer hr_organization_units.organization_id%type;
4567: l_current_le hr_organization_units.organization_id%type; --4363057
4568: l_payroll_action_id pay_payroll_actions.payroll_action_id%type ;
4569: l_year_start pay_payroll_Actions.effective_date%type;

Line 4568: l_payroll_action_id pay_payroll_actions.payroll_action_id%type ;

4564: l_assignment_id pay_assignment_actions.assignment_id%type;
4565: l_business_group_id pay_payroll_actions.business_group_id%type ;
4566: l_registered_employer hr_organization_units.organization_id%type;
4567: l_current_le hr_organization_units.organization_id%type; --4363057
4568: l_payroll_action_id pay_payroll_actions.payroll_action_id%type ;
4569: l_year_start pay_payroll_Actions.effective_date%type;
4570: l_year_end pay_payroll_actions.effective_date%type;
4571: l_employee_type per_all_people_f.current_Employee_Flag%type;
4572: l_current_employee_flag per_all_people_f.current_employee_flag%type :='Y';

Line 4569: l_year_start pay_payroll_Actions.effective_date%type;

4565: l_business_group_id pay_payroll_actions.business_group_id%type ;
4566: l_registered_employer hr_organization_units.organization_id%type;
4567: l_current_le hr_organization_units.organization_id%type; --4363057
4568: l_payroll_action_id pay_payroll_actions.payroll_action_id%type ;
4569: l_year_start pay_payroll_Actions.effective_date%type;
4570: l_year_end pay_payroll_actions.effective_date%type;
4571: l_employee_type per_all_people_f.current_Employee_Flag%type;
4572: l_current_employee_flag per_all_people_f.current_employee_flag%type :='Y';
4573: l_actual_termination_date per_periods_of_service.actual_termination_date%TYPE;

Line 4570: l_year_end pay_payroll_actions.effective_date%type;

4566: l_registered_employer hr_organization_units.organization_id%type;
4567: l_current_le hr_organization_units.organization_id%type; --4363057
4568: l_payroll_action_id pay_payroll_actions.payroll_action_id%type ;
4569: l_year_start pay_payroll_Actions.effective_date%type;
4570: l_year_end pay_payroll_actions.effective_date%type;
4571: l_employee_type per_all_people_f.current_Employee_Flag%type;
4572: l_current_employee_flag per_all_people_f.current_employee_flag%type :='Y';
4573: l_actual_termination_date per_periods_of_service.actual_termination_date%TYPE;
4574: l_date_start per_periods_of_service.date_start%TYPE;

Line 4575: l_asg_start pay_payroll_actions.effective_date%type;

4571: l_employee_type per_all_people_f.current_Employee_Flag%type;
4572: l_current_employee_flag per_all_people_f.current_employee_flag%type :='Y';
4573: l_actual_termination_date per_periods_of_service.actual_termination_date%TYPE;
4574: l_date_start per_periods_of_service.date_start%TYPE;
4575: l_asg_start pay_payroll_actions.effective_date%type;
4576: l_asg_end pay_payroll_actions.effective_date%type;
4577: l_effective_date pay_payroll_actions.effective_date%type;
4578: l_death_benefit_type varchar2(100);
4579: l_assignment_action_id pay_assignment_actions.assignment_action_id%type;

Line 4576: l_asg_end pay_payroll_actions.effective_date%type;

4572: l_current_employee_flag per_all_people_f.current_employee_flag%type :='Y';
4573: l_actual_termination_date per_periods_of_service.actual_termination_date%TYPE;
4574: l_date_start per_periods_of_service.date_start%TYPE;
4575: l_asg_start pay_payroll_actions.effective_date%type;
4576: l_asg_end pay_payroll_actions.effective_date%type;
4577: l_effective_date pay_payroll_actions.effective_date%type;
4578: l_death_benefit_type varchar2(100);
4579: l_assignment_action_id pay_assignment_actions.assignment_action_id%type;
4580: l_max_assignment_action_id pay_assignment_actions.assignment_action_id%type;

Line 4577: l_effective_date pay_payroll_actions.effective_date%type;

4573: l_actual_termination_date per_periods_of_service.actual_termination_date%TYPE;
4574: l_date_start per_periods_of_service.date_start%TYPE;
4575: l_asg_start pay_payroll_actions.effective_date%type;
4576: l_asg_end pay_payroll_actions.effective_date%type;
4577: l_effective_date pay_payroll_actions.effective_date%type;
4578: l_death_benefit_type varchar2(100);
4579: l_assignment_action_id pay_assignment_actions.assignment_action_id%type;
4580: l_max_assignment_action_id pay_assignment_actions.assignment_action_id%type;
4581: l_bbr_assignment_action_id pay_assignment_actions.assignment_action_id%type;

Line 4615: , pay_payroll_actions ppa

4611: , to_date('01-07-'|| substr(pay_core_utils.get_parameter('FINANCIAL_YEAR',ppa.legislative_parameters),1,4),'DD-MM-YYYY')
4612: , to_date('30-06-'|| substr(pay_core_utils.get_parameter('FINANCIAL_YEAR',ppa.legislative_parameters),6,4),'DD-MM-YYYY')
4613: , pay_core_utils.get_parameter('LST_YR_TERM',ppa.legislative_parameters) /*Bug3661230*/
4614: from pay_assignment_actions paa
4615: , pay_payroll_actions ppa
4616: where paa.assignment_action_id = c_assignment_action_id
4617: and ppa.payroll_action_id = paa.payroll_action_id ;
4618: --
4619: -------------------------------------------------+

Line 4626: ,c_lst_year_start in pay_payroll_actions.effective_date%type --3263659

4622: -------------------------------------------------+
4623: --
4624: cursor etp_code
4625: (c_assignment_id in pay_assignment_actions.assignment_id%type
4626: ,c_lst_year_start in pay_payroll_actions.effective_date%type --3263659
4627: ,c_year_start in pay_payroll_actions.effective_date%type
4628: ,c_year_end in pay_payroll_actions.effective_date%type
4629: ,c_def_bal_id in pay_defined_balances.defined_balance_id%type
4630: ,c_business_group_id in pay_payroll_actions.business_group_id%type

Line 4627: ,c_year_start in pay_payroll_actions.effective_date%type

4623: --
4624: cursor etp_code
4625: (c_assignment_id in pay_assignment_actions.assignment_id%type
4626: ,c_lst_year_start in pay_payroll_actions.effective_date%type --3263659
4627: ,c_year_start in pay_payroll_actions.effective_date%type
4628: ,c_year_end in pay_payroll_actions.effective_date%type
4629: ,c_def_bal_id in pay_defined_balances.defined_balance_id%type
4630: ,c_business_group_id in pay_payroll_actions.business_group_id%type
4631: ) is

Line 4628: ,c_year_end in pay_payroll_actions.effective_date%type

4624: cursor etp_code
4625: (c_assignment_id in pay_assignment_actions.assignment_id%type
4626: ,c_lst_year_start in pay_payroll_actions.effective_date%type --3263659
4627: ,c_year_start in pay_payroll_actions.effective_date%type
4628: ,c_year_end in pay_payroll_actions.effective_date%type
4629: ,c_def_bal_id in pay_defined_balances.defined_balance_id%type
4630: ,c_business_group_id in pay_payroll_actions.business_group_id%type
4631: ) is
4632: select distinct nvl(current_employee_flag,'N') current_employee_flag,

Line 4630: ,c_business_group_id in pay_payroll_actions.business_group_id%type

4626: ,c_lst_year_start in pay_payroll_actions.effective_date%type --3263659
4627: ,c_year_start in pay_payroll_actions.effective_date%type
4628: ,c_year_end in pay_payroll_actions.effective_date%type
4629: ,c_def_bal_id in pay_defined_balances.defined_balance_id%type
4630: ,c_business_group_id in pay_payroll_actions.business_group_id%type
4631: ) is
4632: select distinct nvl(current_employee_flag,'N') current_employee_flag,
4633: actual_termination_date,
4634: date_start,

Line 4642: pay_payroll_actions pa,

4638: from per_all_people_f p,
4639: per_all_assignments_f a,
4640: per_periods_of_service pps,
4641: pay_all_payrolls_f papf, --4281290
4642: pay_payroll_actions pa,
4643: pay_assignment_actions ppa
4644: where a.person_id = p.person_id
4645: and pps.person_id = p.person_id
4646: and a.assignment_id = ppa.assignment_id

Line 4684: from pay_payroll_actions ppa,

4680: --
4681: --3263659
4682: cursor cr_effective_date (c_assignment_action_id pay_assignment_actions.assignment_action_id%type) IS
4683: select ppa.effective_date
4684: from pay_payroll_actions ppa,
4685: pay_assignment_actions paa
4686: where paa.assignment_action_id = c_assignment_action_id
4687: and ppa.payroll_action_id = paa.payroll_action_id;
4688: --

Line 4720: pay_payroll_actions ppa,

4716: ) is
4717: select to_number(substr(max(lpad(paa.action_sequence,15,'0')||paa.assignment_action_id),16)) assignment_action_id,
4718: max(paa.action_sequence) action_sequence
4719: from pay_assignment_actions paa,
4720: pay_payroll_actions ppa,
4721: per_assignments_f paf
4722: where paa.assignment_id = paf.assignment_id
4723: and paf.assignment_id = c_assignment_id
4724: and ppa.payroll_action_id = paa.payroll_action_id

Line 4745: ,c_year_start pay_payroll_actions.effective_date%type

4741: */
4742: cursor csr_check_eff_le
4743: (c_assignment_id per_assignments_f.assignment_id%type
4744: ,c_legal_employer hr_organization_units.organization_id%type
4745: ,c_year_start pay_payroll_actions.effective_date%type
4746: ,c_year_end pay_payroll_actions.effective_date%type
4747: ) is
4748: select paaf.assignment_id
4749: from per_assignments_f paaf,

Line 4746: ,c_year_end pay_payroll_actions.effective_date%type

4742: cursor csr_check_eff_le
4743: (c_assignment_id per_assignments_f.assignment_id%type
4744: ,c_legal_employer hr_organization_units.organization_id%type
4745: ,c_year_start pay_payroll_actions.effective_date%type
4746: ,c_year_end pay_payroll_actions.effective_date%type
4747: ) is
4748: select paaf.assignment_id
4749: from per_assignments_f paaf,
4750: hr_soft_coding_keyflex hsck

Line 4761: ,c_year_start pay_payroll_actions.effective_date%type

4757:
4758: /* Bug 5371102 - Added joins on Payroll ID for better performance */
4759: cursor csr_get_dates
4760: (c_assignment_id per_assignments_f.assignment_id%type
4761: ,c_year_start pay_payroll_actions.effective_date%type
4762: ,c_year_end pay_payroll_actions.effective_date%type
4763: ,c_legal_employer hr_organization_units.organization_id%type
4764: ) is
4765: select to_char(min(ppa.effective_date),'DDMMYYYY'), to_char(max(ppa.effective_date),'DDMMYYYY')

Line 4762: ,c_year_end pay_payroll_actions.effective_date%type

4758: /* Bug 5371102 - Added joins on Payroll ID for better performance */
4759: cursor csr_get_dates
4760: (c_assignment_id per_assignments_f.assignment_id%type
4761: ,c_year_start pay_payroll_actions.effective_date%type
4762: ,c_year_end pay_payroll_actions.effective_date%type
4763: ,c_legal_employer hr_organization_units.organization_id%type
4764: ) is
4765: select to_char(min(ppa.effective_date),'DDMMYYYY'), to_char(max(ppa.effective_date),'DDMMYYYY')
4766: from pay_assignment_actions paa,

Line 4767: pay_payroll_actions ppa,

4763: ,c_legal_employer hr_organization_units.organization_id%type
4764: ) is
4765: select to_char(min(ppa.effective_date),'DDMMYYYY'), to_char(max(ppa.effective_date),'DDMMYYYY')
4766: from pay_assignment_actions paa,
4767: pay_payroll_actions ppa,
4768: per_assignments_f paaf
4769: where paa.assignment_id = paaf.assignment_id
4770: and paaf.assignment_id = c_assignment_id
4771: and paa.payroll_action_id = ppa.payroll_action_id

Line 4784: ,c_year_end pay_payroll_actions.effective_date%type

4780: -- assignment between FBT year start and financial year end.
4781: --
4782: cursor csr_get_end_le
4783: (c_assignment_id per_assignments_f.assignment_id%type
4784: ,c_year_end pay_payroll_actions.effective_date%type
4785: ,c_year_start pay_payroll_actions.effective_date%type
4786: ) is
4787: select hsck.segment1
4788: from per_assignments_f paaf,

Line 4785: ,c_year_start pay_payroll_actions.effective_date%type

4781: --
4782: cursor csr_get_end_le
4783: (c_assignment_id per_assignments_f.assignment_id%type
4784: ,c_year_end pay_payroll_actions.effective_date%type
4785: ,c_year_start pay_payroll_actions.effective_date%type
4786: ) is
4787: select hsck.segment1
4788: from per_assignments_f paaf,
4789: hr_soft_coding_keyflex hsck

Line 5655: (p_payroll_action_id in pay_payroll_actions.payroll_action_id%type)

5651: -- Following Procedure is created as per enhancement - Bug#3132178
5652: -- This procedure checks if TEST_EFILE flag is TRUE then submit a request for Magtape Process
5653:
5654: procedure spawn_data_file
5655: (p_payroll_action_id in pay_payroll_actions.payroll_action_id%type)
5656: is
5657:
5658: ps_request_id NUMBER;
5659: l_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE;

Line 5659: l_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE;

5655: (p_payroll_action_id in pay_payroll_actions.payroll_action_id%type)
5656: is
5657:
5658: ps_request_id NUMBER;
5659: l_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE;
5660: l_business_group_id number;
5661: l_start_date date;
5662: l_end_date date;
5663: l_effective_date date;

Line 5676: CURSOR csr_magtape_params(c_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE)

5672: -- Description : Fetches User Parameters from Legislative_paramters
5673: -- column.
5674: --------------------------------------------------------------------+
5675:
5676: CURSOR csr_magtape_params(c_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE)
5677: IS
5678: SELECT pay_core_utils.get_parameter('TEST_EFILE',legislative_parameters) TEST_EFILE,
5679: pay_core_utils.get_parameter('BUSINESS_GROUP_ID',legislative_parameters) BUSINESS_GROUP_ID,
5680: pay_core_utils.get_parameter('FINANCIAL_YEAR',legislative_parameters) FINANCIAL_YEAR,

Line 5685: FROM pay_payroll_actions ppa

5681: pay_core_utils.get_parameter('REGISTERED_EMPLOYER',legislative_parameters) REGISTERED_EMPLOYER,
5682: to_date(pay_core_utils.get_parameter('START_DATE',legislative_parameters),'YYYY/MM/DD') start_date,
5683: to_date(pay_core_utils.get_parameter('END_DATE',legislative_parameters),'YYYY/MM/DD') end_date,
5684: to_date(pay_core_utils.get_parameter('EFFECTIVE_DATE',legislative_parameters),'YYYY/MM/DD') EFFECTIVE_DATE
5685: FROM pay_payroll_actions ppa
5686: WHERE ppa.payroll_action_id = c_payroll_action_id;
5687:
5688:
5689: CURSOR csr_lookup_code (c_financial_year varchar2)