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_PAYROLL_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 123: added pay_payroll_actions.

119: Modified cursor c_get_dedn_elements and c_get_earn_elements. Removed
120: the condition and paa1.source_action_id is not null.
121: 02-AUG-2006 saurgupt 115.24 5332346 Reverse the changes done in populate_actions_ids. Only modified the
122: cursor c_get_all_aaid_for_mast by removing pay_run_types and instead
123: added pay_payroll_actions.
124: 06-FEB-2007 kvsankar 115.25 5865549 Initialized the value of l_asg_action_id
125: to NULL before using it.
126: 03-MAR-2008 sneelapa 115.26 6636807 Modified Procedure populate_action_ids
127: CURSOR c_get_max_action_id

Line 129: pay_payroll_actions.action_type column

125: to NULL before using it.
126: 03-MAR-2008 sneelapa 115.26 6636807 Modified Procedure populate_action_ids
127: CURSOR c_get_max_action_id
128: Added 'V' in WHERE Condition for
129: pay_payroll_actions.action_type column
130: *****************************************************************************/
131:
132: l_package VARCHAR2(30) := 'pay_us_soe_balances_pkg.';
133:

Line 161: ,pay_payroll_actions ppa

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
165: and ((ppa.run_type_id is null and assact.source_action_id is null) or

Line 169: from pay_payroll_actions rpact

165: and ((ppa.run_type_id is null and assact.source_action_id is null) or
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

Line 191: from pay_payroll_actions rpact

187: and assact.source_action_id is not null
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

Line 224: pay_payroll_actions pac

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')
228: -- 'V' action_type is added by sneelapa for bug 6636807

Line 233: from pay_payroll_actions rpact

229: and nvl(pac.date_earned, pac.effective_date) <= c_period_end_date -- Bug 3464757
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

Line 462: pay_payroll_actions ppa

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:
466: -- Cursor to get elements processed from the element entries.

Line 484: pay_payroll_actions ppa ,

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
488: where paa.assignment_action_id = cp_assignment_action_id

Line 585: l_date_earned pay_payroll_actions.date_earned%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;
589: l_processing_priority pay_element_types_f.processing_priority%type;

Line 586: l_date_paid pay_payroll_actions.effective_date%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;
589: l_processing_priority pay_element_types_f.processing_priority%type;
590:

Line 2673: pay_payroll_actions ppa ,

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
2677: where paa.assignment_action_id = cp_assignment_action_id

Line 2741: l_date_earned pay_payroll_actions.date_earned%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;
2745:

Line 2742: l_date_paid pay_payroll_actions.effective_date%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;
2745:
2746: