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

Line 886: SELECT pay_assignment_actions_s.NEXTVAL

882: if check_assignment_tax_ref(csr_rec.assignment_id,l_tax_reference,l_benefit_end_date) then
883: if l_prev_assignment_id IS NULL OR l_prev_assignment_id <> csr_rec.assignment_id
884: THEN
885: -- CREATE THE ARCHIVE ASSIGNMENT ACTION FOR THE MASTER ASSIGNMENT ACTION
886: SELECT pay_assignment_actions_s.NEXTVAL
887: INTO l_actid
888: FROM DUAL;
889:
890: hr_utility.set_location('Archive assignment Action ', 30);

Line 918: SELECT pay_assignment_actions_s.NEXTVAL

914: if check_assignment_tax_ref(csr_rec.assignment_id,l_tax_reference,l_benefit_end_date) then
915: if l_prev_assignment_id IS NULL OR l_prev_assignment_id <> csr_rec.assignment_id
916: THEN
917: -- CREATE THE ARCHIVE ASSIGNMENT ACTION FOR THE MASTER ASSIGNMENT ACTION
918: SELECT pay_assignment_actions_s.NEXTVAL
919: INTO l_actid
920: FROM DUAL;
921:
922: hr_utility.set_location('Archive assignment Action ', 30);

Line 951: SELECT pay_assignment_actions_s.NEXTVAL

947: if check_assignment_tax_ref(csr_rec.assignment_id,l_tax_reference,l_benefit_end_date) then
948: IF l_prev_assignment_id IS NULL OR l_prev_assignment_id <> csr_rec.assignment_id
949: THEN
950: -- CREATE THE ARCHIVE ASSIGNMENT ACTION FOR THE MASTER ASSIGNMENT ACTION
951: SELECT pay_assignment_actions_s.NEXTVAL
952: INTO l_actid
953: FROM DUAL;
954: hr_utility.set_location('Archive assignment Action ', 30);
955: hr_nonrun_asact.insact(l_actid, csr_rec.assignment_id, pactid, CHUNK, NULL);

Line 1030: pay_assignment_actions paa,

1026: SELECT paa.assignment_action_id, pai_person.action_information1, pai_comp.action_information6,
1027: pai_comp.action_information7
1028: FROM pay_action_information pai_comp,
1029: pay_action_information pai_person,
1030: pay_assignment_actions paa,
1031: pay_payroll_actions ppa
1032: WHERE ppa.payroll_action_id = g_pactid
1033: AND paa.payroll_action_id = ppa.payroll_action_id
1034: AND pai_comp.action_context_id = paa.assignment_action_id

Line 1043: CURSOR csr_val_element_entry_id(v_assactid pay_assignment_actions.assignment_action_id%TYPE,

1039: AND pai_person.action_information1 = p_person_id
1040: AND pai_comp.action_information6 = p_emp_ref
1041: AND pai_comp.action_information7 = p_emp_name;
1042:
1043: CURSOR csr_val_element_entry_id(v_assactid pay_assignment_actions.assignment_action_id%TYPE,
1044: v_benefit_start_date VARCHAR2,
1045: v_benefit_end_date VARCHAR2)
1046: IS
1047: SELECT DISTINCT pet.element_type_id element_type_id, peev.element_entry_id element_entry_id,

Line 1056: pay_assignment_actions paac

1052: pay_input_values_f piv,
1053: pay_element_entry_values_f peev,
1054: pay_element_entries_f pee,
1055: per_assignments_f paa,
1056: pay_assignment_actions paac
1057: WHERE pet.classification_id = pec.classification_id AND
1058: pet.element_type_id = piv.element_type_id AND
1059: piv.input_value_id = peev.input_value_id AND
1060: pee.element_entry_id = peev.element_entry_id AND

Line 1818: from pay_assignment_actions paa,

1814: l_count NUMBER(15);
1815:
1816: cursor c_get_per_det is
1817: select paa.payroll_action_id, paaf.person_id
1818: from pay_assignment_actions paa,
1819: per_all_assignments_f paaf
1820: where paa.assignment_action_id = p_ass_act_id
1821: and paa.assignment_id = paaf.assignment_id;
1822:

Line 1829: pay_assignment_actions paa,

1825: select 'Y'
1826: from dual
1827: where exists (select 'X'
1828: from pay_action_information pai,
1829: pay_assignment_actions paa,
1830: per_all_assignments_f paaf
1831: where paaf.person_id = c_person_id
1832: and paaf.assignment_id = paa.assignment_id
1833: and paa.payroll_action_id = c_payroll_action_id

Line 3798: pay_assignment_actions paa,

3794: -- 4248907 Perf fix - csr_incorrect_ni_percentage - Broken into 2 separate cursors
3795: CURSOR csr_incorrect_ni_num IS
3796: SELECT pai.action_information7 action_information7, COUNT(1) temp_num
3797: FROM pay_payroll_actions ppa,
3798: pay_assignment_actions paa,
3799: pay_action_information pai,
3800: pay_action_information pai_emp
3801: WHERE ppa.payroll_action_id = pactid
3802: AND paa.payroll_action_id = ppa.payroll_action_id

Line 3817: pay_assignment_actions paa,

3813:
3814: CURSOR csr_total_num(p_employer_name varchar2) IS
3815: SELECT pai.action_information7 action_information7, COUNT(1) tot_num
3816: FROM pay_payroll_actions ppa,
3817: pay_assignment_actions paa,
3818: pay_action_information pai
3819: WHERE ppa.payroll_action_id = pactid
3820: AND paa.payroll_action_id = ppa.payroll_action_id
3821: AND pai.action_context_id = paa.assignment_action_id

Line 3831: pay_assignment_actions paa,

3827: CURSOR csr_expenses_payment_chk
3828: IS
3829: SELECT COUNT(DISTINCT pai_ben.action_information10)
3830: FROM pay_payroll_actions ppa,
3831: pay_assignment_actions paa,
3832: pay_action_information pai_ben
3833: WHERE ppa.payroll_action_id = pactid
3834: AND ppa.payroll_action_id = paa .payroll_action_id
3835: AND pai_ben.action_context_id = paa.assignment_action_id

Line 3860: pay_assignment_actions paa,

3856: -- 'EXPENSES PAYMENTS', pai.action_information8,
3857: '0') ) p11db_value
3858: FROM pay_action_information pai_comp,
3859: pay_action_information pai,
3860: pay_assignment_actions paa,
3861: pay_payroll_actions ppa
3862: WHERE ppa.payroll_action_id = pactid
3863: AND ppa.payroll_action_id = paa .payroll_action_id
3864: AND pai_comp.action_context_id = paa.assignment_action_id

Line 3894: from pay_assignment_actions paa,

3890: ppa.action_information9,
3891: ppa.action_information10,
3892: ppa.action_information11,
3893: ppa.action_information12
3894: from pay_assignment_actions paa,
3895: pay_action_information ppa
3896: where paa.payroll_action_id = pactid
3897: and paa.assignment_action_id = ppa.action_context_id
3898: and ppa.action_information_category = 'GB EMPLOYEE DETAILS'

Line 3990: from pay_assignment_actions paa,

3986: PROCEDURE write_summary(p_pact_id number) IS
3987:
3988: cursor get_employer(p_pact_id number) is
3989: select action_information7
3990: from pay_assignment_actions paa,
3991: pay_action_information pai
3992: where paa.payroll_action_id = p_pact_id
3993: and pai.action_context_id = paa.assignment_action_id
3994: and pai.action_information_category = 'EMEA PAYROLL INFO'

Line 4042: from pay_assignment_actions paa,

4038: 'OTHER ITEMS', 'M',
4039: 'OTHER ITEMS NON 1A', 'M',
4040: 'EXPENSES PAYMENTS', 'N') cat,
4041: count(*) no_of_entries
4042: from pay_assignment_actions paa,
4043: pay_action_information pai,
4044: pay_action_information pai_a,
4045: pay_action_information pai_person
4046: where paa.payroll_action_id = p_pact_id

Line 4065: from pay_assignment_actions paa,

4061: /* Added for the bug 8513401*/
4062: cursor get_int_free_total(p_pact_id number, p_emp_name varchar2) is
4063: select sum(decode(pai.action_information_category,
4064: 'INT FREE AND LOW INT LOANS', pai.action_information11)) total
4065: from pay_assignment_actions paa,
4066: pay_action_information pai,
4067: pay_action_information pai_a,
4068: pay_action_information pai_person
4069: where paa.payroll_action_id = p_pact_id

Line 4100: from pay_assignment_actions paa,

4096: -- modified for Bug 12314320
4097: sum(nonclassA) from
4098: (select
4099: max(pai.action_information12) as nonclassA --Modified for the bug 11727875
4100: from pay_assignment_actions paa,
4101: pay_action_information pai,
4102: pay_action_information pai_person,
4103: pay_action_information pai_add
4104: where paa.payroll_action_id = p_pact_id

Line 4120: from pay_assignment_actions paa,

4116: select /*+ ORDERED use_nl(paf,paa,pai,pai_person)
4117: use_index(pai_person,pay_action_information_n2)
4118: use_index(pai,pay_action_information_n2) */
4119: sum(pai.action_information11) -- Cash Equivalent For Fuel
4120: from pay_assignment_actions paa,
4121: pay_action_information pai,
4122: pay_action_information pai_person
4123: where paa.payroll_action_id = p_pact_id
4124: and pai.action_context_id = paa.assignment_action_id

Line 4137: from pay_assignment_actions paa,

4133: select /*+ ORDERED use_nl(paf,paa,pai,pai_person)
4134: use_index(pai_person,pay_action_information_n2)
4135: use_index(pai,pay_action_information_n2) */
4136: sum(pai.action_information30) -- Cash Equivalent For Fuel
4137: from pay_assignment_actions paa,
4138: pay_action_information pai,
4139: pay_action_information pai_person
4140: where paa.payroll_action_id = p_pact_id
4141: and pai.action_context_id = paa.assignment_action_id

Line 4157: from pay_assignment_actions paa,

4153: from (select /*+ ORDERED use_nl(paf,paa,pai,pai_person)
4154: use_index(pai_person,pay_action_information_n2)
4155: use_index(pai,pay_action_information_n2) */
4156: pai_person.action_information10 -- Person id
4157: from pay_assignment_actions paa,
4158: pay_action_information pai,
4159: pay_action_information pai_person
4160: where paa.payroll_action_id = p_pact_id
4161: and pai.action_context_id = paa.assignment_action_id

Line 4331: pay_assignment_actions paa,

4327: substr(pml.line_text,instr(pml.line_text,':') + 2) line_text,
4328: substr(pml.line_text,6,instr(pml.line_text,':') - 6) element_name,
4329: pml.line_sequence
4330: from pay_payroll_actions pay,
4331: pay_assignment_actions paa,
4332: per_all_assignments_f paf,
4333: per_all_people_f pap,
4334: per_periods_of_service pos,
4335: pay_message_lines pml