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 163: G_payroll_id pay_payroll_actions.payroll_id%TYPE := NULL;

159: l_gfuta_rt NUMBER;
160: l_futa_change_count NUMBER;
161: -- define some global variables for temporary storage
162: G_asgn_action_id pay_assignment_actions.assignment_action_id%TYPE := NULL;
163: G_payroll_id pay_payroll_actions.payroll_id%TYPE := NULL;
164: G_got_fed_rate BOOLEAN := FALSE;
165: G_ss_ee_rate NUMBER := NULL;
166: G_ss_er_rate NUMBER := NULL;
167: G_medi_ee_rate NUMBER := NULL;

Line 257: G_leg_param pay_payroll_actions.legislative_parameters%TYPE;

253:
254: -- Global variables to hold vales fetched by c_get_payroll_stuff cursor
255: G_as_of_date DATE := NULL;
256: G_business_id per_all_assignments_f.business_group_id%TYPE;
257: G_leg_param pay_payroll_actions.legislative_parameters%TYPE;
258:
259: -- Cursor and global variable to store the futa_override rate
260: G_futa_override_rt NUMBER := 0;
261:

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

268: AND org_information_context = 'Federal Tax Rules';
269:
270: -- cursor c_get_payroll_stuff made public
271: -- It will now be called once in action_creation
272: CURSOR c_get_payroll_stuff(IN_pact_id IN pay_payroll_actions.payroll_action_id%TYPE) IS
273: SELECT effective_date, business_group_id, legislative_parameters
274: FROM pay_payroll_actions
275: WHERE payroll_action_id = IN_pact_id;
276:

Line 274: FROM pay_payroll_actions

270: -- cursor c_get_payroll_stuff made public
271: -- It will now be called once in action_creation
272: CURSOR c_get_payroll_stuff(IN_pact_id IN pay_payroll_actions.payroll_action_id%TYPE) IS
273: SELECT effective_date, business_group_id, legislative_parameters
274: FROM pay_payroll_actions
275: WHERE payroll_action_id = IN_pact_id;
276:
277: CURSOR c_get_futa_rate(p_as_of_date DATE) IS
278: SELECT futa_rate

Line 321: from pay_payroll_actions

317: BEGIN
318: BEGIN
319: select effective_date,legislative_parameters
320: into ld_effective_date,lv_leg_param
321: from pay_payroll_actions
322: where payroll_action_id = IN_pactid;
323:
324: END;
325:

Line 344: INDEX (ppa PAY_PAYROLL_ACTIONS_PK)

340:
341: -- range cursor query
342: lv_sqlstr :=
343: 'SELECT /*+ ORDERED
344: INDEX (ppa PAY_PAYROLL_ACTIONS_PK)
345: INDEX (pa1 PAY_PAYROLL_ACTIONS_N5)
346: INDEX (act PAY_ASSIGNMENT_ACTIONS_N50)
347: INDEX (paf PER_ASSIGNMENTS_F_PK) */
348: DISTINCT paf.person_id

Line 345: INDEX (pa1 PAY_PAYROLL_ACTIONS_N5)

341: -- range cursor query
342: lv_sqlstr :=
343: 'SELECT /*+ ORDERED
344: INDEX (ppa PAY_PAYROLL_ACTIONS_PK)
345: INDEX (pa1 PAY_PAYROLL_ACTIONS_N5)
346: INDEX (act PAY_ASSIGNMENT_ACTIONS_N50)
347: INDEX (paf PER_ASSIGNMENTS_F_PK) */
348: DISTINCT paf.person_id
349: FROM pay_payroll_actions ppa,

Line 349: FROM pay_payroll_actions ppa,

345: INDEX (pa1 PAY_PAYROLL_ACTIONS_N5)
346: INDEX (act PAY_ASSIGNMENT_ACTIONS_N50)
347: INDEX (paf PER_ASSIGNMENTS_F_PK) */
348: DISTINCT paf.person_id
349: FROM pay_payroll_actions ppa,
350: pay_payroll_actions pa1,
351: pay_assignment_actions act,
352: per_assignments_f paf
353: WHERE ppa.payroll_action_id = :payroll_action_id

Line 350: pay_payroll_actions pa1,

346: INDEX (act PAY_ASSIGNMENT_ACTIONS_N50)
347: INDEX (paf PER_ASSIGNMENTS_F_PK) */
348: DISTINCT paf.person_id
349: FROM pay_payroll_actions ppa,
350: pay_payroll_actions pa1,
351: pay_assignment_actions act,
352: per_assignments_f paf
353: WHERE ppa.payroll_action_id = :payroll_action_id
354: AND pa1.effective_date >= fnd_date.canonical_to_date('''|| lv_cur_date ||''')

Line 500: INDEX(ppa PAY_PAYROLL_ACTIONS_PK) */

496: FROM per_all_assignments_f paf,
497: pay_all_payrolls_f PPY
498: WHERE exists
499: (select /*+ INDEX(paa PAY_ASSIGNMENT_ACTIONS_N51)
500: INDEX(ppa PAY_PAYROLL_ACTIONS_PK) */
501: 'x'
502: from pay_payroll_actions ppa,
503: pay_assignment_actions paa
504: where ppa.effective_date between cp_period_start

Line 502: from pay_payroll_actions ppa,

498: WHERE exists
499: (select /*+ INDEX(paa PAY_ASSIGNMENT_ACTIONS_N51)
500: INDEX(ppa PAY_PAYROLL_ACTIONS_PK) */
501: 'x'
502: from pay_payroll_actions ppa,
503: pay_assignment_actions paa
504: where ppa.effective_date between cp_period_start
505: and cp_period_end
506: and ppa.action_type in ('R','Q','V','B','I')

Line 547: pay_payroll_actions ppa,

543: /* Change for Performance Bug 6360505 */
544: SELECT /*+ ORDERED */
545: to_number(substr(max(lpad(paa.action_sequence,15,'0')||paa.assignment_action_id),16)) assignment_action_id
546: FROM per_all_assignments_f paf,
547: pay_payroll_actions ppa,
548: pay_assignment_actions paa,
549: pay_action_classifications pac
550: WHERE paf.person_id = cp_person_id
551: AND paf.payroll_id = ppa.payroll_id

Line 585: pay_payroll_actions ppa,

581: paf.location_id,
582: paf.organization_id,
583: paf.assignment_number
584: FROM pay_assignment_actions paa,
585: pay_payroll_actions ppa,
586: per_all_assignments_f paf
587: WHERE paa.assignment_action_id = cp_asg_act_id
588: AND paa.tax_unit_id = cp_tax_unit_id
589: AND ppa.payroll_action_id = paa.payroll_action_id

Line 610: L_leg_param pay_payroll_actions.legislative_parameters%TYPE;

606: L_assignid NUMBER;
607: L_greid NUMBER;
608: L_as_of_date DATE := NULL;
609: L_start_date DATE;
610: L_leg_param pay_payroll_actions.legislative_parameters%TYPE;
611: L_gre_id pay_assignment_actions.tax_unit_id%TYPE;
612: L_org_id per_all_assignments_f.organization_id%TYPE;
613: L_location_id per_all_assignments_f.location_id%TYPE;
614: L_business_id per_all_assignments_f.business_group_id%TYPE;

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

822: hr_locations loc,
823: per_people_f ppf,
824: per_all_assignments_f paf,
825: pay_assignment_actions paa1, /* PYUGEN assignment action */
826: pay_payroll_actions ppa1 /* PYUGEN payroll action id */
827: WHERE ppa1.payroll_action_id = :pactid
828: AND paa1.payroll_action_id = ppa1.payroll_action_id
829: AND paa1.assignment_id = paf.assignment_id
830: AND paf.effective_start_date =

Line 892: L_token_val pay_payroll_actions.legislative_parameters%TYPE;

888: IN_parameter_list IN VARCHAR2) RETURN VARCHAR2
889: IS
890: L_start_ptr NUMBER;
891: L_end_ptr NUMBER;
892: L_token_val pay_payroll_actions.legislative_parameters%TYPE;
893: L_par_value pay_payroll_actions.legislative_parameters%TYPE;
894: BEGIN
895:
896: L_token_val := IN_name||'=';

Line 893: L_par_value pay_payroll_actions.legislative_parameters%TYPE;

889: IS
890: L_start_ptr NUMBER;
891: L_end_ptr NUMBER;
892: L_token_val pay_payroll_actions.legislative_parameters%TYPE;
893: L_par_value pay_payroll_actions.legislative_parameters%TYPE;
894: BEGIN
895:
896: L_token_val := IN_name||'=';
897: L_start_ptr := INSTR(IN_parameter_list, L_token_val)

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

1828:
1829: return: None
1830: specs:
1831: **************************************************************************/
1832: PROCEDURE prc_process_data(IN_pact_id IN pay_payroll_actions.payroll_action_id%TYPE,
1833: IN_chunk_no IN NUMBER,
1834: IN_commit_count IN NUMBER DEFAULT 1000,
1835: IN_prc_lockingactid IN pay_assignment_actions.assignment_action_id%TYPE,
1836: IN_prc_lockedactid IN pay_assignment_actions.assignment_action_id%TYPE,

Line 2015: FROM pay_payroll_actions ppa,

2011: OR IN_state_code IS NULL)
2012: -- AND pus.state_code = NVL(IN_state_code, pus.state_code)
2013: AND EXISTS (
2014: SELECT 'X'
2015: FROM pay_payroll_actions ppa,
2016: pay_assignment_actions paa,
2017: pay_run_results prr
2018: WHERE action_type IN ('B','I','R','Q','V')
2019: AND ppa.action_status = 'C'

Line 2060: FROM pay_payroll_actions ppa,

2056: OR IN_state_code IS NULL)
2057: --AND pus.state_code = NVL(IN_state_code, pus.state_code)
2058: AND EXISTS (
2059: SELECT 'X'
2060: FROM pay_payroll_actions ppa,
2061: pay_assignment_actions paa,
2062: pay_run_results prr
2063: WHERE action_type IN ('B','I','R','Q','V')
2064: AND ppa.action_status = 'C'

Line 2107: FROM pay_payroll_actions ppa,

2103: OR IN_state_code IS NULL)
2104: -- AND pus.state_code = NVL(IN_state_code, pus.state_code)
2105: AND EXISTS (
2106: SELECT 'X'
2107: FROM pay_payroll_actions ppa,
2108: pay_assignment_actions paa,
2109: pay_run_results prr
2110: WHERE action_type IN ('B','I','R','Q','V')
2111: AND ppa.action_status = 'C'

Line 2157: FROM pay_payroll_actions ppa,

2153: AND (pus.state_code = IN_state_code
2154: OR IN_state_code IS NULL)
2155: AND EXISTS (
2156: SELECT 'X'
2157: FROM pay_payroll_actions ppa,
2158: pay_assignment_actions paa,
2159: pay_run_results prr
2160: WHERE action_type IN ('B','I','R','Q','V')
2161: AND ppa.action_status = 'C'

Line 2199: FROM pay_payroll_actions ppa,

2195: AND (pus.state_code = IN_state_code
2196: OR IN_state_code IS NULL)
2197: AND EXISTS (
2198: SELECT 'X'
2199: FROM pay_payroll_actions ppa,
2200: pay_assignment_actions paa,
2201: pay_run_results prr
2202: WHERE action_type IN ('B','I','R','Q','V')
2203: AND ppa.action_status = 'C'

Line 2227: L_leg_param pay_payroll_actions.legislative_parameters%TYPE;

2223: AND effective_end_date >= IN_as_of_date;
2224:
2225: L_as_of_date DATE := NULL;
2226: L_start_date DATE ;
2227: L_leg_param pay_payroll_actions.legislative_parameters%TYPE;
2228: L_gre_id pay_assignment_actions.tax_unit_id%TYPE;
2229: L_org_id per_all_assignments_f.organization_id%TYPE;
2230: L_location_id per_all_assignments_f.location_id%TYPE;
2231: L_business_id per_all_assignments_f.business_group_id%TYPE;