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.PAYUSUNB_PKG dependencies on PAY_PAYROLL_ACTIONS

Line 102: G_payroll_id pay_payroll_actions.payroll_id%TYPE := NULL;

98: c_fixed_futa_rt CONSTANT NUMBER(10,4) := 6.2;
99:
100: -- define some global variables for temporary storage
101: G_asgn_action_id pay_assignment_actions.assignment_action_id%TYPE := NULL;
102: G_payroll_id pay_payroll_actions.payroll_id%TYPE := NULL;
103: G_got_fed_rate BOOLEAN := FALSE;
104: G_ss_ee_rate NUMBER := NULL;
105: G_ss_er_rate NUMBER := NULL;
106: G_medi_ee_rate NUMBER := NULL;

Line 196: G_leg_param pay_payroll_actions.legislative_parameters%TYPE;

192:
193: -- Global variables to hold vales fetched by c_get_payroll_stuff cursor
194: G_as_of_date DATE := NULL;
195: G_business_id per_all_assignments_f.business_group_id%TYPE;
196: G_leg_param pay_payroll_actions.legislative_parameters%TYPE;
197:
198: -- Cursor and global variable to store the futa_override rate
199: G_futa_override_rt NUMBER := 0;
200:

Line 211: CURSOR c_get_payroll_stuff(IN_pact_id IN pay_payroll_actions.payroll_action_id%TYPE) IS

207: AND org_information_context = 'Federal Tax Rules';
208:
209: -- cursor c_get_payroll_stuff made public
210: -- It will now be called once in action_creation
211: CURSOR c_get_payroll_stuff(IN_pact_id IN pay_payroll_actions.payroll_action_id%TYPE) IS
212: SELECT effective_date, business_group_id, legislative_parameters
213: FROM pay_payroll_actions
214: WHERE payroll_action_id = IN_pact_id;
215:

Line 213: FROM pay_payroll_actions

209: -- cursor c_get_payroll_stuff made public
210: -- It will now be called once in action_creation
211: CURSOR c_get_payroll_stuff(IN_pact_id IN pay_payroll_actions.payroll_action_id%TYPE) IS
212: SELECT effective_date, business_group_id, legislative_parameters
213: FROM pay_payroll_actions
214: WHERE payroll_action_id = IN_pact_id;
215:
216: /***************** 3005756 END ******************************/
217:

Line 244: from pay_payroll_actions

240: BEGIN
241: BEGIN
242: select effective_date,legislative_parameters
243: into ld_effective_date,lv_leg_param
244: from pay_payroll_actions
245: where payroll_action_id = IN_pactid;
246:
247: END;
248:

Line 267: INDEX (ppa PAY_PAYROLL_ACTIONS_PK)

263:
264: -- range cursor query
265: lv_sqlstr :=
266: 'SELECT /*+ ORDERED
267: INDEX (ppa PAY_PAYROLL_ACTIONS_PK)
268: INDEX (pa1 PAY_PAYROLL_ACTIONS_N5)
269: INDEX (act PAY_ASSIGNMENT_ACTIONS_N50)
270: INDEX (paf PER_ASSIGNMENTS_F_PK) */
271: DISTINCT paf.person_id

Line 268: INDEX (pa1 PAY_PAYROLL_ACTIONS_N5)

264: -- range cursor query
265: lv_sqlstr :=
266: 'SELECT /*+ ORDERED
267: INDEX (ppa PAY_PAYROLL_ACTIONS_PK)
268: INDEX (pa1 PAY_PAYROLL_ACTIONS_N5)
269: INDEX (act PAY_ASSIGNMENT_ACTIONS_N50)
270: INDEX (paf PER_ASSIGNMENTS_F_PK) */
271: DISTINCT paf.person_id
272: FROM pay_payroll_actions ppa,

Line 272: FROM pay_payroll_actions ppa,

268: INDEX (pa1 PAY_PAYROLL_ACTIONS_N5)
269: INDEX (act PAY_ASSIGNMENT_ACTIONS_N50)
270: INDEX (paf PER_ASSIGNMENTS_F_PK) */
271: DISTINCT paf.person_id
272: FROM pay_payroll_actions ppa,
273: pay_payroll_actions pa1,
274: pay_assignment_actions act,
275: per_assignments_f paf
276: WHERE ppa.payroll_action_id = :payroll_action_id

Line 273: pay_payroll_actions pa1,

269: INDEX (act PAY_ASSIGNMENT_ACTIONS_N50)
270: INDEX (paf PER_ASSIGNMENTS_F_PK) */
271: DISTINCT paf.person_id
272: FROM pay_payroll_actions ppa,
273: pay_payroll_actions pa1,
274: pay_assignment_actions act,
275: per_assignments_f paf
276: WHERE ppa.payroll_action_id = :payroll_action_id
277: AND pa1.effective_date >= fnd_date.canonical_to_date('''|| lv_cur_date ||''')

Line 330: INDEX(ppa PAY_PAYROLL_ACTIONS_PK) */

326: FROM per_all_assignments_f paf,
327: pay_all_payrolls_f PPY
328: WHERE exists
329: (select /*+ INDEX(paa PAY_ASSIGNMENT_ACTIONS_N51)
330: INDEX(ppa PAY_PAYROLL_ACTIONS_PK) */
331: 'x'
332: from pay_payroll_actions ppa,
333: pay_assignment_actions paa
334: where ppa.effective_date between cp_period_start

Line 332: from pay_payroll_actions ppa,

328: WHERE exists
329: (select /*+ INDEX(paa PAY_ASSIGNMENT_ACTIONS_N51)
330: INDEX(ppa PAY_PAYROLL_ACTIONS_PK) */
331: 'x'
332: from pay_payroll_actions ppa,
333: pay_assignment_actions paa
334: where ppa.effective_date between cp_period_start
335: and cp_period_end
336: and ppa.action_type in ('R','Q','V','B','I')

Line 377: pay_payroll_actions ppa,

373: /* Change for Performance Bug 6360505 */
374: SELECT /*+ ORDERED */
375: to_number(substr(max(lpad(paa.action_sequence,15,'0')||paa.assignment_action_id),16)) assignment_action_id
376: FROM per_all_assignments_f paf,
377: pay_payroll_actions ppa,
378: pay_assignment_actions paa,
379: pay_action_classifications pac
380: WHERE paf.person_id = cp_person_id
381: AND paf.payroll_id = ppa.payroll_id

Line 415: pay_payroll_actions ppa,

411: paf.location_id,
412: paf.organization_id,
413: paf.assignment_number
414: FROM pay_assignment_actions paa,
415: pay_payroll_actions ppa,
416: per_all_assignments_f paf
417: WHERE paa.assignment_action_id = cp_asg_act_id
418: AND paa.tax_unit_id = cp_tax_unit_id
419: AND ppa.payroll_action_id = paa.payroll_action_id

Line 433: L_leg_param pay_payroll_actions.legislative_parameters%TYPE;

429: L_assignid NUMBER;
430: L_greid NUMBER;
431: L_as_of_date DATE := NULL;
432: L_start_date DATE;
433: L_leg_param pay_payroll_actions.legislative_parameters%TYPE;
434: L_gre_id pay_assignment_actions.tax_unit_id%TYPE;
435: L_org_id per_all_assignments_f.organization_id%TYPE;
436: L_location_id per_all_assignments_f.location_id%TYPE;
437: L_business_id per_all_assignments_f.business_group_id%TYPE;

Line 595: pay_payroll_actions ppa1 /* PYUGEN payroll action id */

591: hr_locations loc,
592: per_people_f ppf,
593: per_all_assignments_f paf,
594: pay_assignment_actions paa1, /* PYUGEN assignment action */
595: pay_payroll_actions ppa1 /* PYUGEN payroll action id */
596: WHERE ppa1.payroll_action_id = :pactid
597: AND paa1.payroll_action_id = ppa1.payroll_action_id
598: AND paa1.assignment_id = paf.assignment_id
599: AND paf.effective_start_date =

Line 661: L_token_val pay_payroll_actions.legislative_parameters%TYPE;

657: IN_parameter_list IN VARCHAR2) RETURN VARCHAR2
658: IS
659: L_start_ptr NUMBER;
660: L_end_ptr NUMBER;
661: L_token_val pay_payroll_actions.legislative_parameters%TYPE;
662: L_par_value pay_payroll_actions.legislative_parameters%TYPE;
663: BEGIN
664:
665: L_token_val := IN_name||'=';

Line 662: L_par_value pay_payroll_actions.legislative_parameters%TYPE;

658: IS
659: L_start_ptr NUMBER;
660: L_end_ptr NUMBER;
661: L_token_val pay_payroll_actions.legislative_parameters%TYPE;
662: L_par_value pay_payroll_actions.legislative_parameters%TYPE;
663: BEGIN
664:
665: L_token_val := IN_name||'=';
666: L_start_ptr := INSTR(IN_parameter_list, L_token_val)

Line 1347: PROCEDURE prc_process_data(IN_pact_id IN pay_payroll_actions.payroll_action_id%TYPE,

1343:
1344: return: None
1345: specs:
1346: **************************************************************************/
1347: PROCEDURE prc_process_data(IN_pact_id IN pay_payroll_actions.payroll_action_id%TYPE,
1348: IN_chunk_no IN NUMBER,
1349: IN_commit_count IN NUMBER DEFAULT 1000,
1350: IN_prc_lockingactid IN pay_assignment_actions.assignment_action_id%TYPE,
1351: IN_prc_lockedactid IN pay_assignment_actions.assignment_action_id%TYPE,

Line 1527: FROM pay_payroll_actions ppa,

1523: OR IN_state_code IS NULL)
1524: -- AND pus.state_code = NVL(IN_state_code, pus.state_code)
1525: AND EXISTS (
1526: SELECT 'X'
1527: FROM pay_payroll_actions ppa,
1528: pay_assignment_actions paa,
1529: pay_run_results prr
1530: WHERE action_type IN ('B','I','R','Q','V')
1531: AND ppa.action_status = 'C'

Line 1572: FROM pay_payroll_actions ppa,

1568: OR IN_state_code IS NULL)
1569: --AND pus.state_code = NVL(IN_state_code, pus.state_code)
1570: AND EXISTS (
1571: SELECT 'X'
1572: FROM pay_payroll_actions ppa,
1573: pay_assignment_actions paa,
1574: pay_run_results prr
1575: WHERE action_type IN ('B','I','R','Q','V')
1576: AND ppa.action_status = 'C'

Line 1619: FROM pay_payroll_actions ppa,

1615: OR IN_state_code IS NULL)
1616: -- AND pus.state_code = NVL(IN_state_code, pus.state_code)
1617: AND EXISTS (
1618: SELECT 'X'
1619: FROM pay_payroll_actions ppa,
1620: pay_assignment_actions paa,
1621: pay_run_results prr
1622: WHERE action_type IN ('B','I','R','Q','V')
1623: AND ppa.action_status = 'C'

Line 1669: FROM pay_payroll_actions ppa,

1665: AND (pus.state_code = IN_state_code
1666: OR IN_state_code IS NULL)
1667: AND EXISTS (
1668: SELECT 'X'
1669: FROM pay_payroll_actions ppa,
1670: pay_assignment_actions paa,
1671: pay_run_results prr
1672: WHERE action_type IN ('B','I','R','Q','V')
1673: AND ppa.action_status = 'C'

Line 1711: FROM pay_payroll_actions ppa,

1707: AND (pus.state_code = IN_state_code
1708: OR IN_state_code IS NULL)
1709: AND EXISTS (
1710: SELECT 'X'
1711: FROM pay_payroll_actions ppa,
1712: pay_assignment_actions paa,
1713: pay_run_results prr
1714: WHERE action_type IN ('B','I','R','Q','V')
1715: AND ppa.action_status = 'C'

Line 1739: L_leg_param pay_payroll_actions.legislative_parameters%TYPE;

1735: AND effective_end_date >= IN_as_of_date;
1736:
1737: L_as_of_date DATE := NULL;
1738: L_start_date DATE ;
1739: L_leg_param pay_payroll_actions.legislative_parameters%TYPE;
1740: L_gre_id pay_assignment_actions.tax_unit_id%TYPE;
1741: L_org_id per_all_assignments_f.organization_id%TYPE;
1742: L_location_id per_all_assignments_f.location_id%TYPE;
1743: L_business_id per_all_assignments_f.business_group_id%TYPE;