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

Line 679: pay_assignment_actions paa,

675:
676: lv_sql_string :=
677: 'select distinct paf.person_id
678: from per_assignments_f paf,
679: pay_assignment_actions paa,
680: pay_payroll_actions ppa
681: where ppa.business_group_id = ''' || ln_business_group_id || '''
682: and paf.assignment_id = paa.assignment_id
683: and ppa.effective_date between paf.effective_start_date

Line 736: pay_assignment_actions paa,

732: paa.tax_unit_id,
733: paa.assignment_id,
734: ppa.effective_date
735: from per_assignments_f paf,
736: pay_assignment_actions paa,
737: pay_payroll_actions ppa
738: where paf.person_id between cp_start_person_id
739: and cp_end_person_id
740: and ppa.effective_date between paf.effective_start_date

Line 758: pay_assignment_actions paa1,

754: and paa.action_status = 'C'
755: and not exists
756: (select 1
757: from pay_action_interlocks pai,
758: pay_assignment_actions paa1,
759: pay_payroll_actions ppa1
760: where pai.locked_action_id = paa.assignment_action_id
761: and paa1.assignment_action_id = pai.locking_action_id
762: and ppa1.payroll_action_id = paa1.payroll_action_id

Line 782: pay_assignment_actions paa,

778: paa.assignment_id,
779: ppa.effective_date
780: from per_assignments_f paf,
781: pay_us_emp_state_tax_rules_f pest,
782: pay_assignment_actions paa,
783: pay_payroll_actions ppa
784: where paf.person_id between cp_start_person_id
785: and cp_end_person_id
786: and ppa.effective_date between paf.effective_start_date

Line 808: pay_assignment_actions paa1,

804: and paa.action_status = 'C'
805: and not exists
806: (select 1
807: from pay_action_interlocks pai,
808: pay_assignment_actions paa1,
809: pay_payroll_actions ppa1
810: where pai.locked_action_id = paa.assignment_action_id
811: and paa1.assignment_action_id = pai.locking_action_id
812: and ppa1.payroll_action_id = paa1.payroll_action_id

Line 827: select /*+ INDEX(paa PAY_ASSIGNMENT_ACTIONS_N51)

823: and pest.effective_end_Date;
824:
825: cursor c_get_latest_action(cp_assignment_id number
826: ,cp_tax_unit_id number) is
827: select /*+ INDEX(paa PAY_ASSIGNMENT_ACTIONS_N51)
828: INDEX(ppa PAY_PAYROLL_ACTIONS_PK) */
829: paa.assignment_action_id, ppa.effective_date,
830: ppa.payroll_id, ppa.consolidation_set_id
831: from pay_assignment_actions paa,

Line 831: from pay_assignment_actions paa,

827: select /*+ INDEX(paa PAY_ASSIGNMENT_ACTIONS_N51)
828: INDEX(ppa PAY_PAYROLL_ACTIONS_PK) */
829: paa.assignment_action_id, ppa.effective_date,
830: ppa.payroll_id, ppa.consolidation_set_id
831: from pay_assignment_actions paa,
832: pay_payroll_actions ppa
833: where paa.assignment_id = cp_assignment_id
834: and paa.tax_unit_id = cp_tax_unit_id
835: and paa.payroll_action_id = ppa.payroll_action_id

Line 1000: select pay_assignment_actions_s.nextval

996: hr_utility.trace('Adj Flag = '||lv_adj_flag );
997: if lv_adj_flag = 'Y' then
998: hr_utility.set_location(gv_package || lv_procedure_name, 60);
999:
1000: select pay_assignment_actions_s.nextval
1001: into ln_adj_action_id
1002: from dual;
1003:
1004: -- insert into pay_assignment_actions.

Line 1004: -- insert into pay_assignment_actions.

1000: select pay_assignment_actions_s.nextval
1001: into ln_adj_action_id
1002: from dual;
1003:
1004: -- insert into pay_assignment_actions.
1005: hr_nonrun_asact.insact(ln_adj_action_id,
1006: ln_run_assignment_id,
1007: p_payroll_action_id,
1008: p_chunk,

Line 1032: update pay_assignment_actions

1028: lv_serial_number := to_char(ld_run_effective_Date,'ddmmyyyy') ||
1029: ln_max_run_action_id;
1030:
1031: hr_utility.trace('Update Serail Number = ' || lv_serial_number);
1032: update pay_assignment_actions
1033: set serial_number = lv_serial_number
1034: where assignment_action_id = ln_adj_action_id;
1035:
1036: hr_utility.trace('Insert into temp table ');

Line 1261: from pay_assignment_actions paa,

1257: where state_Abbrev = cp_state_abbrev;
1258:
1259: cursor c_get_chunk_date(cp_payroll_action_id in number) is
1260: select min(paa.chunk_number)
1261: from pay_assignment_actions paa,
1262: pay_payroll_actions ppa
1263: where ppa.payroll_action_id = paa.payroll_Action_id
1264: and ppa.payroll_action_id = cp_payroll_action_id;
1265:

Line 1346: from pay_assignment_actions

1342: BEGIN
1343:
1344: select count(*)
1345: into ln_count_incomplete_actions
1346: from pay_assignment_actions
1347: where payroll_action_id = p_payroll_action_id
1348: and action_status <> 'C';
1349:
1350: if ln_count_incomplete_actions = 0 then

Line 1385: l_payroll_action_id pay_assignment_actions.payroll_action_id%type;

1381: PROCEDURE run_preprocess(
1382: p_assignment_action_id number
1383: ,p_effective_date in date)
1384: IS
1385: l_payroll_action_id pay_assignment_actions.payroll_action_id%type;
1386: l_chunk_number pay_assignment_actions.chunk_number%type;
1387:
1388: cursor cur_assignment_action_info
1389: (cp_assignment_action_id in number) is

Line 1386: l_chunk_number pay_assignment_actions.chunk_number%type;

1382: p_assignment_action_id number
1383: ,p_effective_date in date)
1384: IS
1385: l_payroll_action_id pay_assignment_actions.payroll_action_id%type;
1386: l_chunk_number pay_assignment_actions.chunk_number%type;
1387:
1388: cursor cur_assignment_action_info
1389: (cp_assignment_action_id in number) is
1390: select

Line 1396: from pay_assignment_actions paa

1392: paa.assignment_id,
1393: paa.tax_unit_id,
1394: paa.payroll_action_id,
1395: to_number(substr(paa.serial_number,9)) bal_asg_action_id
1396: from pay_assignment_actions paa
1397: where paa.assignment_action_id = cp_assignment_action_id;
1398:
1399: cursor get_asg_run_info(cp_run_action_id in number) is
1400: select payroll_id, consolidation_set_id

Line 1402: ,pay_assignment_actions paa

1398:
1399: cursor get_asg_run_info(cp_run_action_id in number) is
1400: select payroll_id, consolidation_set_id
1401: from pay_payroll_actions ppa
1402: ,pay_assignment_actions paa
1403: where ppa.payroll_Action_id = paa.payroll_action_id
1404: and paa.assignment_action_id = cp_run_action_id;
1405:
1406: cursor csr_chk_state(cp_assignment_id in number

Line 1431: select /*+ INDEX(paa PAY_ASSIGNMENT_ACTIONS_N51)

1427: and value1 = cp_consolidation_id;
1428:
1429: cursor c_get_per_latest_action(cp_assignment_id number
1430: ,cp_tax_unit_id number) is
1431: select /*+ INDEX(paa PAY_ASSIGNMENT_ACTIONS_N51)
1432: INDEX(ppa PAY_PAYROLL_ACTIONS_PK) */
1433: paa.assignment_action_id
1434: from pay_assignment_actions paa,
1435: per_all_assignments_f paf,

Line 1434: from pay_assignment_actions paa,

1430: ,cp_tax_unit_id number) is
1431: select /*+ INDEX(paa PAY_ASSIGNMENT_ACTIONS_N51)
1432: INDEX(ppa PAY_PAYROLL_ACTIONS_PK) */
1433: paa.assignment_action_id
1434: from pay_assignment_actions paa,
1435: per_all_assignments_f paf,
1436: per_all_assignments_f paf1,
1437: pay_payroll_actions ppa
1438: where paf1.assignment_id = cp_assignment_id

Line 1536: from pay_assignment_actions

1532: select payroll_action_id,
1533: chunk_number
1534: into l_payroll_action_id,
1535: l_chunk_number
1536: from pay_assignment_actions
1537: where assignment_action_id = p_assignment_action_id;
1538: --
1539: process_min_chunk(p_payroll_action_id => l_payroll_action_id,
1540: p_chunk_number => l_chunk_number);