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_CA_T4AEOY_ARCHIVE dependencies on PAY_ASSIGNMENT_ACTIONS

Line 537: l_assignment_action_id pay_assignment_actions.assignment_action_id%type;

533: that are created. */
534:
535: l_payroll_action_created boolean := false;
536: l_payroll_action_id pay_payroll_actions.payroll_action_id%type;
537: l_assignment_action_id pay_assignment_actions.assignment_action_id%type;
538:
539: /* Variable holding the balance to be tested. */
540:
541: l_defined_balance_id pay_defined_balances.defined_balance_id%type;

Line 585: l_primary_asg pay_assignment_actions.assignment_id%type;

581: l_quarter_end date;
582: l_year_start date;
583: l_year_end date;
584: lockingactid number;
585: l_primary_asg pay_assignment_actions.assignment_id%type;
586: l_legislative_parameters varchar2(240);
587: l_max_aaid number;
588:
589:

Line 599: pay_assignment_actions paa,

595: ASG.assignment_id assignment_id,
596: paa.tax_unit_id tax_unit_id,
597: ASG.effective_end_date effective_end_date
598: FROM per_all_assignments_f ASG,
599: pay_assignment_actions paa,
600: pay_payroll_actions ppa
601: WHERE ppa.payroll_action_id >= 0
602: AND ppa.effective_date between l_period_start
603: and l_period_end

Line 624: pay_assignment_actions paa,

620: ASG.assignment_id assignment_id,
621: paa.tax_unit_id tax_unit_id,
622: ASG.effective_end_date effective_end_date
623: FROM per_all_assignments_f ASG,
624: pay_assignment_actions paa,
625: pay_payroll_actions ppa,
626: per_all_people_f ppf
627: WHERE ppa.effective_date between l_period_start
628: and l_period_end

Line 653: pay_assignment_actions paa,

649: ASG.assignment_id assignment_id,
650: paa.tax_unit_id tax_unit_id,
651: ASG.effective_end_date effective_end_date
652: FROM per_all_assignments_f ASG,
653: pay_assignment_actions paa,
654: pay_payroll_actions ppa,
655: per_all_people_f ppf,
656: pay_population_ranges ppr
657: WHERE ppa.effective_date between l_period_start

Line 884: from pay_assignment_actions paa1,

880:
881: begin
882: select paa1.assignment_action_id
883: into l_max_aaid
884: from pay_assignment_actions paa1,
885: per_all_assignments_f paf2,
886: pay_payroll_actions ppa2,
887: pay_action_classifications pac2
888: where paf2.person_id = l_person_id

Line 901: pay_assignment_actions paa,

897: l_period_end
898: and not exists (select ''
899: FROM pay_action_classifications pac,
900: pay_payroll_actions ppa,
901: pay_assignment_actions paa,
902: per_all_assignments_f paf1
903: WHERE paf1.person_id = l_person_id
904: AND paa.assignment_id = paf1.assignment_id
905: AND paa.tax_unit_id = l_tax_unit_id

Line 942: select pay_assignment_actions_s.nextval

938: <> 0) ) then
939: /* Create the assignment action to represnt the person / tax unit
940: combination. */
941:
942: select pay_assignment_actions_s.nextval
943: into lockingactid
944: from dual;
945:
946: /* Insert into pay_assignment_actions. */

Line 946: /* Insert into pay_assignment_actions. */

942: select pay_assignment_actions_s.nextval
943: into lockingactid
944: from dual;
945:
946: /* Insert into pay_assignment_actions. */
947:
948: hr_utility.trace('creating assignment action');
949:
950: hr_nonrun_asact.insact(lockingactid,l_primary_asg,

Line 961: update pay_assignment_actions aa

957: */
958:
959: hr_utility.trace('updating assignment action');
960:
961: update pay_assignment_actions aa
962: set aa.serial_number = to_char(l_person_id)
963: where aa.assignment_action_id = lockingactid;
964: end if; /* End of Gross Earning <> 0 */
965: end if ; /*l_max_aaid <> -9999 */

Line 1872: from pay_assignment_actions paa

1868: l_step number := 0;
1869:
1870: cursor c_get_min_chunk is
1871: select min(paa.chunk_number)
1872: from pay_assignment_actions paa
1873: where paa.payroll_action_id = p_payroll_action_id;
1874:
1875: begin
1876: open c_get_min_chunk;

Line 1908: l_aaid pay_assignment_actions.assignment_action_id%type;

1904: procedure eoy_archive_data_new_format(p_assactid in number,
1905: p_effective_date in date,
1906: p_negative_balance_exists in varchar2 default 'N') is
1907:
1908: l_aaid pay_assignment_actions.assignment_action_id%type;
1909: l_aaseq pay_assignment_actions.action_sequence%type;
1910: l_asgid pay_assignment_actions.assignment_id%type;
1911: l_date_earned date;
1912: l_user_entity_name_tab pay_ca_t4aeoy_archive.char240_data_type_table;

Line 1909: l_aaseq pay_assignment_actions.action_sequence%type;

1905: p_effective_date in date,
1906: p_negative_balance_exists in varchar2 default 'N') is
1907:
1908: l_aaid pay_assignment_actions.assignment_action_id%type;
1909: l_aaseq pay_assignment_actions.action_sequence%type;
1910: l_asgid pay_assignment_actions.assignment_id%type;
1911: l_date_earned date;
1912: l_user_entity_name_tab pay_ca_t4aeoy_archive.char240_data_type_table;
1913: l_balance_type_tab pay_ca_t4aeoy_archive.char240_data_type_table;

Line 1910: l_asgid pay_assignment_actions.assignment_id%type;

1906: p_negative_balance_exists in varchar2 default 'N') is
1907:
1908: l_aaid pay_assignment_actions.assignment_action_id%type;
1909: l_aaseq pay_assignment_actions.action_sequence%type;
1910: l_asgid pay_assignment_actions.assignment_id%type;
1911: l_date_earned date;
1912: l_user_entity_name_tab pay_ca_t4aeoy_archive.char240_data_type_table;
1913: l_balance_type_tab pay_ca_t4aeoy_archive.char240_data_type_table;
1914: l_user_entity_value_tab pay_ca_t4aeoy_archive.char240_data_type_table;

Line 1915: l_tax_unit_id pay_assignment_actions.tax_unit_id%type;

1911: l_date_earned date;
1912: l_user_entity_name_tab pay_ca_t4aeoy_archive.char240_data_type_table;
1913: l_balance_type_tab pay_ca_t4aeoy_archive.char240_data_type_table;
1914: l_user_entity_value_tab pay_ca_t4aeoy_archive.char240_data_type_table;
1915: l_tax_unit_id pay_assignment_actions.tax_unit_id%type;
1916: l_business_group_id pay_assignment_actions.tax_unit_id%type;
1917: l_year_start date;
1918: l_year_end date;
1919: l_count number := 0;

Line 1916: l_business_group_id pay_assignment_actions.tax_unit_id%type;

1912: l_user_entity_name_tab pay_ca_t4aeoy_archive.char240_data_type_table;
1913: l_balance_type_tab pay_ca_t4aeoy_archive.char240_data_type_table;
1914: l_user_entity_value_tab pay_ca_t4aeoy_archive.char240_data_type_table;
1915: l_tax_unit_id pay_assignment_actions.tax_unit_id%type;
1916: l_business_group_id pay_assignment_actions.tax_unit_id%type;
1917: l_year_start date;
1918: l_year_end date;
1919: l_count number := 0;
1920:

Line 2028: , pay_assignment_actions run_paa

2024: , pay_run_results prr
2025: , pay_element_types_f pet
2026: , pay_input_values_f piv1
2027: , pay_input_values_f piv2
2028: , pay_assignment_actions run_paa
2029: , pay_payroll_actions run_ppa
2030: , pay_assignment_actions arch_paa
2031: , pay_payroll_actions arch_ppa
2032: , per_all_assignments_f arch_paf

Line 2030: , pay_assignment_actions arch_paa

2026: , pay_input_values_f piv1
2027: , pay_input_values_f piv2
2028: , pay_assignment_actions run_paa
2029: , pay_payroll_actions run_ppa
2030: , pay_assignment_actions arch_paa
2031: , pay_payroll_actions arch_ppa
2032: , per_all_assignments_f arch_paf
2033: , per_all_assignments_f all_paf
2034: , hr_all_organization_units hou

Line 2093: from pay_assignment_actions paa,

2089: AND ACTION_INFORMATION4 = cp_reg_no;
2090:
2091: CURSOR c_get_latest_asg(p_person_id number ) IS
2092: select paa.assignment_action_id
2093: from pay_assignment_actions paa,
2094: per_all_assignments_f paf,
2095: pay_payroll_actions ppa,
2096: pay_action_classifications pac
2097: where paf.person_id = p_person_id

Line 2121: from pay_payroll_actions ppa,pay_assignment_actions paa

2117: /* New cursors added for Federal YE Amendment Pre-Process Validation */
2118:
2119: CURSOR c_get_fapp_lkd_actid_rtype(cp_locked_actid number) IS
2120: select ppa.report_type
2121: from pay_payroll_actions ppa,pay_assignment_actions paa
2122: where paa.assignment_action_id = cp_locked_actid
2123: and ppa.payroll_action_id = paa.payroll_action_id;
2124:
2125: CURSOR c_get_fapp_locked_action_id(cp_locking_act_id number) IS

Line 2164: FROM pay_assignment_actions aa

2160: l_tax_unit_id,
2161: l_chunk,
2162: l_payroll_action_id,
2163: lv_serial_number
2164: FROM pay_assignment_actions aa
2165: WHERE aa.assignment_action_id = p_assactid;
2166:
2167: /*Bug 4021563 Fetching the Status Indian flag */
2168: open c_get_status_indian(l_asgid,p_effective_date);

Line 3248: l_aaid pay_assignment_actions.assignment_action_id%type;

3244: */
3245:
3246: procedure eoy_archive_data(p_assactid in number, p_effective_date in date) is
3247:
3248: l_aaid pay_assignment_actions.assignment_action_id%type;
3249: l_aaseq pay_assignment_actions.action_sequence%type;
3250: l_asgid pay_assignment_actions.assignment_id%type;
3251: l_date_earned date;
3252: l_user_entity_name_tab pay_ca_t4aeoy_archive.char240_data_type_table;

Line 3249: l_aaseq pay_assignment_actions.action_sequence%type;

3245:
3246: procedure eoy_archive_data(p_assactid in number, p_effective_date in date) is
3247:
3248: l_aaid pay_assignment_actions.assignment_action_id%type;
3249: l_aaseq pay_assignment_actions.action_sequence%type;
3250: l_asgid pay_assignment_actions.assignment_id%type;
3251: l_date_earned date;
3252: l_user_entity_name_tab pay_ca_t4aeoy_archive.char240_data_type_table;
3253: l_balance_type_tab pay_ca_t4aeoy_archive.char240_data_type_table;

Line 3250: l_asgid pay_assignment_actions.assignment_id%type;

3246: procedure eoy_archive_data(p_assactid in number, p_effective_date in date) is
3247:
3248: l_aaid pay_assignment_actions.assignment_action_id%type;
3249: l_aaseq pay_assignment_actions.action_sequence%type;
3250: l_asgid pay_assignment_actions.assignment_id%type;
3251: l_date_earned date;
3252: l_user_entity_name_tab pay_ca_t4aeoy_archive.char240_data_type_table;
3253: l_balance_type_tab pay_ca_t4aeoy_archive.char240_data_type_table;
3254: l_user_entity_value_tab pay_ca_t4aeoy_archive.char240_data_type_table;

Line 3255: l_tax_unit_id pay_assignment_actions.tax_unit_id%type;

3251: l_date_earned date;
3252: l_user_entity_name_tab pay_ca_t4aeoy_archive.char240_data_type_table;
3253: l_balance_type_tab pay_ca_t4aeoy_archive.char240_data_type_table;
3254: l_user_entity_value_tab pay_ca_t4aeoy_archive.char240_data_type_table;
3255: l_tax_unit_id pay_assignment_actions.tax_unit_id%type;
3256: l_business_group_id pay_assignment_actions.tax_unit_id%type;
3257: l_year_start date;
3258: l_year_end date;
3259: l_context_no number := 60;

Line 3256: l_business_group_id pay_assignment_actions.tax_unit_id%type;

3252: l_user_entity_name_tab pay_ca_t4aeoy_archive.char240_data_type_table;
3253: l_balance_type_tab pay_ca_t4aeoy_archive.char240_data_type_table;
3254: l_user_entity_value_tab pay_ca_t4aeoy_archive.char240_data_type_table;
3255: l_tax_unit_id pay_assignment_actions.tax_unit_id%type;
3256: l_business_group_id pay_assignment_actions.tax_unit_id%type;
3257: l_year_start date;
3258: l_year_end date;
3259: l_context_no number := 60;
3260: l_count number := 0;

Line 3441: , pay_assignment_actions run_paa

3437: , pay_run_results prr
3438: , pay_element_types_f pet
3439: , pay_input_values_f piv1
3440: , pay_input_values_f piv2
3441: , pay_assignment_actions run_paa
3442: , pay_payroll_actions run_ppa
3443: , pay_assignment_actions arch_paa
3444: , pay_payroll_actions arch_ppa
3445: , per_all_assignments_f arch_paf

Line 3443: , pay_assignment_actions arch_paa

3439: , pay_input_values_f piv1
3440: , pay_input_values_f piv2
3441: , pay_assignment_actions run_paa
3442: , pay_payroll_actions run_ppa
3443: , pay_assignment_actions arch_paa
3444: , pay_payroll_actions arch_ppa
3445: , per_all_assignments_f arch_paf
3446: , per_all_assignments_f all_paf
3447: , hr_all_organization_units hou

Line 3507: from pay_assignment_actions paa,

3503: AND ACTION_INFORMATION4 = cp_reg_no;
3504:
3505: CURSOR c_get_latest_asg(p_person_id number ) IS
3506: select paa.assignment_action_id
3507: from pay_assignment_actions paa,
3508: per_all_assignments_f paf,
3509: pay_payroll_actions ppa,
3510: pay_action_classifications pac
3511: where paf.person_id = p_person_id

Line 3535: from pay_payroll_actions ppa,pay_assignment_actions paa

3531: /* New cursors added for Federal YE Amendment Pre-Process Validation */
3532:
3533: CURSOR c_get_fapp_lkd_actid_rtype(cp_locked_actid number) IS
3534: select ppa.report_type
3535: from pay_payroll_actions ppa,pay_assignment_actions paa
3536: where paa.assignment_action_id = cp_locked_actid
3537: and ppa.payroll_action_id = paa.payroll_action_id;
3538:
3539: CURSOR c_get_fapp_locked_action_id(cp_locking_act_id number) IS

Line 3577: FROM pay_assignment_actions aa

3573: l_tax_unit_id,
3574: l_chunk,
3575: l_payroll_action_id,
3576: lv_serial_number
3577: FROM pay_assignment_actions aa
3578: WHERE aa.assignment_action_id = p_assactid;
3579:
3580: /*Bug 4021563 Fetching the Status Indian flag */
3581: open c_get_status_indian(l_asgid,p_effective_date);

Line 3629: from pay_assignment_actions paa1,

3625:
3626: /*
3627: select paa1.assignment_action_id
3628: into l_aaid
3629: from pay_assignment_actions paa1,
3630: per_all_assignments_f paf2
3631: where paa1.assignment_id = paf2.assignment_id
3632: and paa1.tax_unit_id = l_tax_unit_id
3633: and (paa1.action_sequence , paf2.person_id) =

Line 3637: pay_assignment_actions paa,

3633: and (paa1.action_sequence , paf2.person_id) =
3634: (SELECT MAX(paa.action_sequence), paf.person_id
3635: FROM pay_action_classifications pac,
3636: pay_payroll_actions ppa,
3637: pay_assignment_actions paa,
3638: per_all_assignments_f paf1,
3639: per_all_assignments_f paf
3640: WHERE paf.assignment_id = l_asgid
3641: AND paf1.person_id = paf.person_id

Line 5486: PAA PAY_ASSIGNMENT_ACTIONS_N50,

5482: if l_eoy_tax_unit_id <> -99999 then
5483:
5484: sqlstr := 'select /*+ ORDERED INDEX (PPY PAY_PAYROLLS_F_FK2,
5485: PPA PAY_PAYROLL_ACTIONS_N51,
5486: PAA PAY_ASSIGNMENT_ACTIONS_N50,
5487: ASG PER_ASSIGNMENTS_F_PK,
5488: PPA1 PAY_PAYROLL_ACTIONS_PK)
5489: USE_NL(PPY, PPA, PAA, ASG, PPA1) */
5490: distinct asg.person_id

Line 5493: pay_assignment_actions paa,

5489: USE_NL(PPY, PPA, PAA, ASG, PPA1) */
5490: distinct asg.person_id
5491: from pay_all_payrolls_f ppy,
5492: pay_payroll_actions ppa,
5493: pay_assignment_actions paa,
5494: per_all_assignments_f asg,
5495: pay_payroll_actions ppa1
5496: where ppa1.payroll_action_id = :payroll_action_id
5497: and ppa.effective_date between