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

Line 850: l_assignment_action_id pay_assignment_actions.assignment_action_id%type;

846: that are created. */
847:
848: l_payroll_action_created boolean := false;
849: l_payroll_action_id pay_payroll_actions.payroll_action_id%type;
850: l_assignment_action_id pay_assignment_actions.assignment_action_id%type;
851: l_archive_item_id number;
852:
853: /* Variable holding the balance to be tested. */
854:

Line 894: l_primary_asg pay_assignment_actions.assignment_id%type;

890: lockingactid number;
891: l_max_aaid number;
892: l_pre_org_id varchar2(17);
893: l_prev_pre_org_id varchar2(17);
894: l_primary_asg pay_assignment_actions.assignment_id%type;
895: ln_no_gross_earnings number;
896:
897:
898: /* For Year End Preprocess we have to archive the assignments

Line 943: pay_assignment_actions paa,

939: SELECT asg.person_id person_id,
940: asg.assignment_id assignment_id,
941: asg.effective_end_date effective_end_date
942: FROM per_all_assignments_f asg,
943: pay_assignment_actions paa,
944: pay_payroll_actions ppa
945: WHERE ppa.effective_date between l_period_start
946: and l_period_end
947: AND ppa.action_type in ('R','Q','V','B','I')

Line 1000: from pay_assignment_actions paa,

996: cp_tax_unit_id number,
997: cp_period_start date,
998: cp_period_end date) IS
999: select paa.assignment_action_id
1000: from pay_assignment_actions paa,
1001: per_all_assignments_f paf,
1002: per_all_people_f ppf,
1003: pay_payroll_actions ppa,
1004: pay_action_classifications pac

Line 1198: select pay_assignment_actions_s.nextval

1194:
1195: /* Create the assignment action to represnt the person / tax unit
1196: combination. */
1197:
1198: select pay_assignment_actions_s.nextval
1199: into lockingactid
1200: from dual;
1201:
1202: /* Insert into pay_assignment_actions. */

Line 1202: /* Insert into pay_assignment_actions. */

1198: select pay_assignment_actions_s.nextval
1199: into lockingactid
1200: from dual;
1201:
1202: /* Insert into pay_assignment_actions. */
1203:
1204: hr_utility.trace('creating assignment_action');
1205:
1206: /* Passing tax unit id as null */

Line 1219: update pay_assignment_actions aa

1215: */
1216:
1217: hr_utility.trace('updating assignment_action' || to_char(lockingactid));
1218:
1219: update pay_assignment_actions aa
1220: set aa.serial_number = to_char(l_person_id)
1221: where aa.assignment_action_id = lockingactid;
1222:
1223: end if; /* end if l_value <> 0 or ln_no_gross_earnings <> 0 */

Line 1726: from pay_assignment_actions paa

1722: l_step number := 0;
1723:
1724: cursor c_get_min_chunk is
1725: select min(paa.chunk_number)
1726: from pay_assignment_actions paa
1727: where paa.payroll_action_id = p_payroll_action_id;
1728: begin
1729: open c_get_min_chunk;
1730: fetch c_get_min_chunk into g_min_chunk;

Line 1762: l_aaid pay_assignment_actions.assignment_action_id%type;

1758:
1759: PROCEDURE eoy_archive_data(p_assactid in number,
1760: p_effective_date in date) IS
1761:
1762: l_aaid pay_assignment_actions.assignment_action_id%type;
1763: l_aaid1 pay_assignment_actions.assignment_action_id%type;
1764: l_aaseq pay_assignment_actions.action_sequence%type;
1765: l_asgid pay_assignment_actions.assignment_id%type;
1766: l_date_earned date;

Line 1763: l_aaid1 pay_assignment_actions.assignment_action_id%type;

1759: PROCEDURE eoy_archive_data(p_assactid in number,
1760: p_effective_date in date) IS
1761:
1762: l_aaid pay_assignment_actions.assignment_action_id%type;
1763: l_aaid1 pay_assignment_actions.assignment_action_id%type;
1764: l_aaseq pay_assignment_actions.action_sequence%type;
1765: l_asgid pay_assignment_actions.assignment_id%type;
1766: l_date_earned date;
1767: l_tax_unit_id pay_assignment_actions.tax_unit_id%type;

Line 1764: l_aaseq pay_assignment_actions.action_sequence%type;

1760: p_effective_date in date) IS
1761:
1762: l_aaid pay_assignment_actions.assignment_action_id%type;
1763: l_aaid1 pay_assignment_actions.assignment_action_id%type;
1764: l_aaseq pay_assignment_actions.action_sequence%type;
1765: l_asgid pay_assignment_actions.assignment_id%type;
1766: l_date_earned date;
1767: l_tax_unit_id pay_assignment_actions.tax_unit_id%type;
1768: l_reporting_type varchar2(240);

Line 1765: l_asgid pay_assignment_actions.assignment_id%type;

1761:
1762: l_aaid pay_assignment_actions.assignment_action_id%type;
1763: l_aaid1 pay_assignment_actions.assignment_action_id%type;
1764: l_aaseq pay_assignment_actions.action_sequence%type;
1765: l_asgid pay_assignment_actions.assignment_id%type;
1766: l_date_earned date;
1767: l_tax_unit_id pay_assignment_actions.tax_unit_id%type;
1768: l_reporting_type varchar2(240);
1769: l_prev_tax_unit_id pay_assignment_actions.tax_unit_id%type := null;

Line 1767: l_tax_unit_id pay_assignment_actions.tax_unit_id%type;

1763: l_aaid1 pay_assignment_actions.assignment_action_id%type;
1764: l_aaseq pay_assignment_actions.action_sequence%type;
1765: l_asgid pay_assignment_actions.assignment_id%type;
1766: l_date_earned date;
1767: l_tax_unit_id pay_assignment_actions.tax_unit_id%type;
1768: l_reporting_type varchar2(240);
1769: l_prev_tax_unit_id pay_assignment_actions.tax_unit_id%type := null;
1770: l_business_group_id number;
1771: l_year_start date;

Line 1769: l_prev_tax_unit_id pay_assignment_actions.tax_unit_id%type := null;

1765: l_asgid pay_assignment_actions.assignment_id%type;
1766: l_date_earned date;
1767: l_tax_unit_id pay_assignment_actions.tax_unit_id%type;
1768: l_reporting_type varchar2(240);
1769: l_prev_tax_unit_id pay_assignment_actions.tax_unit_id%type := null;
1770: l_business_group_id number;
1771: l_year_start date;
1772: l_year_end date;
1773: l_context_no number := 60;

Line 1865: l_rl2_tax_unit_id pay_assignment_actions.tax_unit_id%type;

1861:
1862: ln_status_indian NUMBER := 0;
1863: ln_index NUMBER;
1864: ln_footnote_index NUMBER;
1865: l_rl2_tax_unit_id pay_assignment_actions.tax_unit_id%type;
1866: lv_footnote_bal varchar2(80);
1867:
1868: l_rl2_source_of_income varchar2(150);
1869: l_per_eit_source_of_income varchar2(150);

Line 1918: pay_assignment_actions paa,

1914: cursor c_all_gres(asgactid number) is
1915: select hoi.organization_id ,
1916: hoi.org_information5
1917: from pay_action_information pac,
1918: pay_assignment_actions paa,
1919: hr_organization_information hoi
1920: where paa.assignment_action_id = asgactid
1921: and pac.action_context_id = paa.payroll_action_id
1922: and pac.action_information_category = 'CAEOY TRANSMITTER INFO'

Line 1934: pay_assignment_actions paa,

1930: cursor c_all_gres_for_footnote(asgactid number) is
1931: select hoi.organization_id ,
1932: hoi.org_information5
1933: from pay_action_information pac,
1934: pay_assignment_actions paa,
1935: hr_organization_information hoi
1936: where paa.assignment_action_id = asgactid
1937: and pac.action_context_id = paa.payroll_action_id
1938: and pac.action_information_category = 'CAEOY TRANSMITTER INFO'

Line 2030: from pay_assignment_actions paa,

2026: cp_tax_unit_id number,
2027: cp_period_start date,
2028: cp_period_end date) IS
2029: select paa.assignment_action_id
2030: from pay_assignment_actions paa,
2031: per_all_assignments_f paf,
2032: per_all_people_f ppf,
2033: pay_payroll_actions ppa,
2034: pay_action_classifications pac,

Line 2104: FROM pay_assignment_actions aa

2100: l_tax_unit_id,
2101: l_chunk,
2102: l_payroll_action_id,
2103: lv_serial_number
2104: FROM pay_assignment_actions aa
2105: WHERE aa.assignment_action_id = p_assactid;
2106:
2107: l_rl2_tax_unit_id := l_tax_unit_id;
2108:

Line 3239: pay_assignment_actions paa,

3235:
3236: sqlstr := 'select distinct asg.person_id
3237: from pay_all_payrolls_f ppy,
3238: pay_payroll_actions ppa,
3239: pay_assignment_actions paa,
3240: per_all_assignments_f asg,
3241: pay_payroll_actions ppa1
3242: where ppa1.payroll_action_id = :payroll_action_id
3243: and ppa.effective_date between