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

Line 101: Now pay_assignment_actions and pay_payroll_actions are used.

97: 23-MAR-2006 saurgupt 115.20 4966938 Changed the cursor c_get_pay_assignment_dtl. Add ppa.effective_date
98: in the select statement.
99: Write the new queries for cursors c_get_earn_elements and
100: c_get_dedn_elements. Removed the table pay_element_entries_f.
101: Now pay_assignment_actions and pay_payroll_actions are used.
102: Also, now date_paid is used in place of date_earned. This resolves
103: the boundary issue if date earned and date paid are in different
104: years.
105: 16-MAY-2006 sodhingr 115.20 5228817 changed cursor c_get_dedn_elements and c_get_earn_elements

Line 160: ,pay_assignment_actions assact

156: IS
157: select assact.assignment_action_id,
158: assact.assignment_id
159: from pay_action_interlocks intlk
160: ,pay_assignment_actions assact
161: ,pay_payroll_actions ppa
162: where intlk.locking_action_id = cp_run_action_id
163: and intlk.locked_action_id = assact.assignment_action_id
164: and assact.payroll_action_id = ppa.payroll_action_id

Line 170: , pay_assignment_actions rassact

166: (ppa.run_type_id is not null and assact.source_action_id is not null))
167: and not exists
168: (select null
169: from pay_payroll_actions rpact
170: , pay_assignment_actions rassact
171: , pay_action_interlocks rintlk
172: where assact.assignment_action_id = rintlk.locked_action_id
173: and rintlk.locking_action_id = rassact.assignment_action_id
174: and rpact.payroll_action_id = rassact.payroll_action_id

Line 183: ,pay_assignment_actions assact

179: assact.assignment_id,
180: prt.shortname,
181: prt.run_type_id
182: from pay_action_interlocks intlk
183: ,pay_assignment_actions assact
184: ,pay_run_types_f prt
185: where intlk.locking_action_id = cp_run_action_id
186: and intlk.locked_action_id = assact.assignment_action_id
187: and assact.source_action_id is not null

Line 192: , pay_assignment_actions rassact

188: and assact.run_type_id(+) = prt.run_type_id
189: and not exists
190: (select null
191: from pay_payroll_actions rpact
192: , pay_assignment_actions rassact
193: , pay_action_interlocks rintlk
194: where assact.assignment_action_id = rintlk.locked_action_id
195: and rintlk.locking_action_id = rassact.assignment_action_id
196: and rpact.payroll_action_id = rassact.payroll_action_id

Line 223: from pay_assignment_actions assact,

219: c_period_end_date date,
220: c_period_start_date date)
221: IS
222: select assact.assignment_action_id -- Bug 3257504
223: from pay_assignment_actions assact,
224: pay_payroll_actions pac
225: where assact.assignment_id = c_assignment_id
226: and assact.payroll_action_id = pac.payroll_action_id
227: and pac.action_type in ('R','Q','B','I','V')

Line 234: , pay_assignment_actions rassact

230: and nvl(pac.date_earned, pac.effective_date) >= trunc(c_period_start_date,'Y') -- Bug 3275404, 3464757
231: and not exists
232: (select null
233: from pay_payroll_actions rpact
234: , pay_assignment_actions rassact
235: , pay_action_interlocks rintlk
236: where assact.assignment_action_id = rintlk.locked_action_id
237: and rintlk.locking_action_id = rassact.assignment_action_id
238: and rpact.payroll_action_id = rassact.payroll_action_id

Line 461: from pay_assignment_actions paa,

457: CURSOR c_get_pay_assignment_dtl(cp_assignment_action_id number) IS
458: select paa.assignment_id,
459: ppa.date_earned,
460: ppa.effective_date
461: from pay_assignment_actions paa,
462: pay_payroll_actions ppa
463: where paa.assignment_action_id = cp_assignment_action_id
464: and paa.payroll_action_id = ppa.payroll_action_id;
465:

Line 482: from pay_assignment_actions paa ,

478: pet.element_information12,
479: pet.business_group_id,
480: pec.classification_name,
481: pet.processing_priority
482: from pay_assignment_actions paa ,
483: pay_assignment_actions paa1 ,
484: pay_payroll_actions ppa ,
485: pay_run_results prr ,
486: pay_element_types_f pet ,

Line 483: pay_assignment_actions paa1 ,

479: pet.business_group_id,
480: pec.classification_name,
481: pet.processing_priority
482: from pay_assignment_actions paa ,
483: pay_assignment_actions paa1 ,
484: pay_payroll_actions ppa ,
485: pay_run_results prr ,
486: pay_element_types_f pet ,
487: pay_element_classifications pec

Line 582: l_assignment_id pay_assignment_actions.assignment_id%type;

578: l_element_type_id pay_element_types_f.element_type_id%type;
579: l_element_reporting_name pay_element_types_f.reporting_name%type;
580: l_element_information10 pay_element_types_f.element_information10%type;
581: l_element_information12 pay_element_types_f.element_information12%type;
582: l_assignment_id pay_assignment_actions.assignment_id%type;
583: l_assignment_action_id pay_assignment_actions.assignment_action_id%type;
584: l_tax_unit_id pay_assignment_actions.tax_unit_id%type;
585: l_date_earned pay_payroll_actions.date_earned%type;
586: l_date_paid pay_payroll_actions.effective_date%type;

Line 583: l_assignment_action_id pay_assignment_actions.assignment_action_id%type;

579: l_element_reporting_name pay_element_types_f.reporting_name%type;
580: l_element_information10 pay_element_types_f.element_information10%type;
581: l_element_information12 pay_element_types_f.element_information12%type;
582: l_assignment_id pay_assignment_actions.assignment_id%type;
583: l_assignment_action_id pay_assignment_actions.assignment_action_id%type;
584: l_tax_unit_id pay_assignment_actions.tax_unit_id%type;
585: l_date_earned pay_payroll_actions.date_earned%type;
586: l_date_paid pay_payroll_actions.effective_date%type;
587: l_business_group_id pay_element_types_f.business_group_id%type;

Line 584: l_tax_unit_id pay_assignment_actions.tax_unit_id%type;

580: l_element_information10 pay_element_types_f.element_information10%type;
581: l_element_information12 pay_element_types_f.element_information12%type;
582: l_assignment_id pay_assignment_actions.assignment_id%type;
583: l_assignment_action_id pay_assignment_actions.assignment_action_id%type;
584: l_tax_unit_id pay_assignment_actions.tax_unit_id%type;
585: l_date_earned pay_payroll_actions.date_earned%type;
586: l_date_paid pay_payroll_actions.effective_date%type;
587: l_business_group_id pay_element_types_f.business_group_id%type;
588: l_classification_name pay_element_classifications.classification_name%type;

Line 2671: from pay_assignment_actions paa ,

2667: nvl(pet.reporting_name, pet.element_name),
2668: pet.element_information10,
2669: pet.business_group_id,
2670: pet.processing_priority
2671: from pay_assignment_actions paa ,
2672: pay_assignment_actions paa1 ,
2673: pay_payroll_actions ppa ,
2674: pay_run_results prr ,
2675: pay_element_types_f pet ,

Line 2672: pay_assignment_actions paa1 ,

2668: pet.element_information10,
2669: pet.business_group_id,
2670: pet.processing_priority
2671: from pay_assignment_actions paa ,
2672: pay_assignment_actions paa1 ,
2673: pay_payroll_actions ppa ,
2674: pay_run_results prr ,
2675: pay_element_types_f pet ,
2676: pay_element_classifications pec

Line 2738: l_assignment_id pay_assignment_actions.assignment_id%type;

2734:
2735: l_element_type_id pay_element_types_f.element_type_id%type;
2736: l_element_reporting_name pay_element_types_f.reporting_name%type;
2737: l_element_information10 pay_element_types_f.element_information10%type;
2738: l_assignment_id pay_assignment_actions.assignment_id%type;
2739: l_assignment_action_id pay_assignment_actions.assignment_action_id%type;
2740: l_tax_unit_id pay_assignment_actions.tax_unit_id%type;
2741: l_date_earned pay_payroll_actions.date_earned%type;
2742: l_date_paid pay_payroll_actions.effective_date%type;

Line 2739: l_assignment_action_id pay_assignment_actions.assignment_action_id%type;

2735: l_element_type_id pay_element_types_f.element_type_id%type;
2736: l_element_reporting_name pay_element_types_f.reporting_name%type;
2737: l_element_information10 pay_element_types_f.element_information10%type;
2738: l_assignment_id pay_assignment_actions.assignment_id%type;
2739: l_assignment_action_id pay_assignment_actions.assignment_action_id%type;
2740: l_tax_unit_id pay_assignment_actions.tax_unit_id%type;
2741: l_date_earned pay_payroll_actions.date_earned%type;
2742: l_date_paid pay_payroll_actions.effective_date%type;
2743: l_business_group_id pay_element_types_f.business_group_id%type;

Line 2740: l_tax_unit_id pay_assignment_actions.tax_unit_id%type;

2736: l_element_reporting_name pay_element_types_f.reporting_name%type;
2737: l_element_information10 pay_element_types_f.element_information10%type;
2738: l_assignment_id pay_assignment_actions.assignment_id%type;
2739: l_assignment_action_id pay_assignment_actions.assignment_action_id%type;
2740: l_tax_unit_id pay_assignment_actions.tax_unit_id%type;
2741: l_date_earned pay_payroll_actions.date_earned%type;
2742: l_date_paid pay_payroll_actions.effective_date%type;
2743: l_business_group_id pay_element_types_f.business_group_id%type;
2744: l_processing_priority pay_element_types_f.processing_priority%type;