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_FR_ARC_PKG dependencies on PAY_PAYROLL_ACTIONS

Line 10: g_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE;

6: g_package CONSTANT VARCHAR2(20):= 'pay_fr_arc_pkg.';
7: --
8: -- Parameters to the process - g_payroll_action_id is the cache context
9: --
10: g_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE;
11: g_param_payroll_id pay_all_payrolls_f.payroll_id%TYPE;
12: g_param_assignment_id per_all_assignments_f.assignment_id%TYPE;
13: g_param_assignment_set_id hr_assignment_sets.assignment_set_id%TYPE;
14: g_param_business_group_id per_business_Groups.business_group_id%TYPE;

Line 164: ,pay_payroll_actions ppa

160: -- Return the select string
161: --
162: sqlstr := 'SELECT DISTINCT person_id
163: FROM per_people_f ppf
164: ,pay_payroll_actions ppa
165: WHERE ppa.payroll_action_id = :payroll_action_id
166: AND ppa.business_group_id = ppf.business_group_id
167: ORDER BY ppf.person_id';
168: --

Line 201: ,pay_payroll_actions pre_payact

197: ,pre_assact.assignment_id assignment_id
198: ,pre_assact.tax_unit_id establishment_id
199: FROM per_all_assignments_f asg
200: ,pay_assignment_actions pre_assact
201: ,pay_payroll_actions pre_payact
202: WHERE asg.person_id between p_stperson and p_endperson
203: and asg.period_of_service_id is not null
204: and g_param_effective_date between asg.effective_start_date
205: and asg.effective_end_date

Line 1270: , pay_payroll_actions run_payact

1266: run_assact.assignment_action_id, proc_type.context_value
1267: FROM pay_action_interlocks arc_interlock
1268: , pay_action_interlocks pre_interlock
1269: , pay_assignment_actions run_assact
1270: , pay_payroll_actions run_payact
1271: , pay_action_contexts proc_type /*will exclude proration actions*/
1272: WHERE arc_interlock.locking_action_id = p_archive_action_id
1273: and pre_interlock.locking_action_id = arc_interlock.locked_action_id
1274: and pre_interlock.locked_action_id = run_assact.assignment_action_id

Line 1288: , pay_payroll_actions rev_payact

1284: CURSOR csr_locking_reversal (p_run_act_id number) is
1285: SELECT 1 /* if the run action is reversed exclude it */
1286: FROM pay_action_interlocks rev_interlock
1287: , pay_assignment_actions rev_assact
1288: , pay_payroll_actions rev_payact
1289: WHERE rev_interlock.locked_action_id = p_run_act_id
1290: AND rev_interlock.locking_action_id = rev_assact.assignment_action_id
1291: AND rev_assact.action_status = 'C'
1292: AND rev_payact.payroll_action_id = rev_assact.payroll_action_id

Line 1428: ,pay_payroll_actions a_ppa

1424: ,p_assignment_action_id number
1425: ,p_assignment_id number) is
1426: select m_ppa.overriding_dd_date
1427: from pay_action_interlocks a_lock
1428: ,pay_payroll_actions a_ppa
1429: ,pay_assignment_Actions a_asg
1430: ,pay_assignment_actions m_asg
1431: ,pay_assignment_actions p_asg
1432: ,pay_payroll_actions m_ppa

Line 1432: ,pay_payroll_actions m_ppa

1428: ,pay_payroll_actions a_ppa
1429: ,pay_assignment_Actions a_asg
1430: ,pay_assignment_actions m_asg
1431: ,pay_assignment_actions p_asg
1432: ,pay_payroll_actions m_ppa
1433: ,pay_action_interlocks m_lock
1434: where a_lock.locking_Action_id = p_assignment_action_id
1435: and a_lock.locked_action_id = a_asg.assignment_Action_id
1436: and a_asg.payroll_action_id = a_ppa.payroll_action_id

Line 2111: ,pay_payroll_actions arc_payact

2107: ,all_arc_lock.locking_action_id)) num_previous
2108: from pay_action_interlocks this_arc_lock
2109: ,pay_action_interlocks all_arc_lock
2110: ,pay_assignment_actions arc_assact
2111: ,pay_payroll_actions arc_payact
2112: ,pay_pre_payments ppp
2113: ,pay_personal_payment_methods_f pppmf
2114: ,pay_org_payment_methods_f_tl opmtl
2115: where this_arc_lock.locking_action_id = p_archive_action_id

Line 2218: -- Select all the messages from pay_payroll_actions.pay_advice_message

2214: ,p_establishment_id in number
2215: ,p_term_atd in date
2216: ,p_term_reason in varchar2) is
2217: --
2218: -- Select all the messages from pay_payroll_actions.pay_advice_message
2219: -- for runs that are locked by this archive assignment action id
2220: -- archiving per assignment allows for future expansion of assignment level
2221: -- messages
2222: --

Line 2228: from pay_payroll_actions pre_payact

2224: --
2225:
2226: cursor csr_message_details(p_archive_assignment_action_id number) is
2227: select substrb(run_payact.pay_advice_message, 1, 240) message
2228: from pay_payroll_actions pre_payact
2229: ,pay_assignment_actions pre_assact
2230: ,pay_payroll_actions run_payact
2231: ,pay_assignment_actions run_assact
2232: ,pay_action_interlocks arc_lock

Line 2230: ,pay_payroll_actions run_payact

2226: cursor csr_message_details(p_archive_assignment_action_id number) is
2227: select substrb(run_payact.pay_advice_message, 1, 240) message
2228: from pay_payroll_actions pre_payact
2229: ,pay_assignment_actions pre_assact
2230: ,pay_payroll_actions run_payact
2231: ,pay_assignment_actions run_assact
2232: ,pay_action_interlocks arc_lock
2233: ,pay_action_interlocks pre_lock
2234: where

Line 2409: ,pay_payroll_actions pre_payact

2405: ,pay_input_values_f_tl piv
2406: ,fnd_lookup_values user_rubric
2407: ,fnd_lookup_values seed_rubric
2408: ,fnd_lookup_values base_units
2409: ,pay_payroll_actions pre_payact
2410: ,pay_assignment_actions pre_assact
2411: ,pay_payroll_actions run_payact
2412: ,pay_assignment_actions run_assact
2413: ,pay_action_interlocks arc_lock

Line 2411: ,pay_payroll_actions run_payact

2407: ,fnd_lookup_values seed_rubric
2408: ,fnd_lookup_values base_units
2409: ,pay_payroll_actions pre_payact
2410: ,pay_assignment_actions pre_assact
2411: ,pay_payroll_actions run_payact
2412: ,pay_assignment_actions run_assact
2413: ,pay_action_interlocks arc_lock
2414: ,pay_action_interlocks pre_lock
2415: ,pay_element_entries_f pee

Line 2483: ,pay_payroll_actions ppa

2479: 'EE',pee.source_end_date,
2480: 'RR',rr_ret.end_date)
2481: ) result_rollup
2482: ,pay_assignment_actions paa
2483: ,pay_payroll_actions ppa
2484: ,per_time_periods ptp
2485: where paa.assignment_action_id (+) = result_rollup.retro_act_id
2486: and ppa.payroll_action_id (+) = paa.payroll_action_id
2487: and ptp.time_period_id (+) = ppa.time_period_id

Line 3031: ,pay_payroll_actions run_payact

3027: ,fnd_lookup_values base_units
3028: ,pay_action_interlocks arc_lock
3029: ,pay_action_interlocks pre_lock
3030: ,pay_assignment_actions run_assact
3031: ,pay_payroll_actions run_payact
3032: where pet.classification_id in (p_ee_classification, p_er_classification)
3033: and (pet.legislation_code = 'FR' or pet.legislation_code is null)
3034: and pet.element_type_id = prr.element_Type_id
3035: and p_effective_date between pet.effective_start_date

Line 3201: l_parameter pay_payroll_actions.legislative_parameters%TYPE:=NULL;

3197: p_parameter_string in varchar2
3198: ,p_token in varchar2
3199: ,p_segment_number in number default null ) RETURN varchar2
3200: IS
3201: l_parameter pay_payroll_actions.legislative_parameters%TYPE:=NULL;
3202: l_start_pos NUMBER;
3203: l_delimiter varchar2(1):=' ';
3204: l_proc VARCHAR2(40):= g_package||' get parameter ';
3205: BEGIN

Line 3249: FROM pay_payroll_actions

3245: ,pay_fr_arc_pkg.get_parameter(legislative_parameters, 'ASSIGNMENT_SET')
3246: ,business_group_id
3247: ,start_date
3248: ,effective_date
3249: FROM pay_payroll_actions
3250: WHERE payroll_action_id = p_payroll_action_id;
3251: l_proc VARCHAR2(40):= g_package||' get_all_parameters ';
3252:
3253: BEGIN

Line 3308: ,pay_payroll_actions ppa

3304: cursor csr_check_archive_org_address (p_payroll_action_id number) is
3305: select action_information4 name
3306: ,ppa.payroll_id payroll_id
3307: from pay_action_information pai
3308: ,pay_payroll_actions ppa
3309: where pai.action_information_category in('FR_SOE_ESTAB_INFORMATION', 'FR_SOE_COMPANY_DETAILS')
3310: and pai.action_information2 is null /* address id */
3311: and pai.action_context_id = p_payroll_action_id
3312: and pai.action_context_id = ppa.payroll_Action_id

Line 3454: , pay_payroll_actions pa

3450: , pay_action_interlocks prelck
3451: , pay_balance_types b
3452: , pay_run_balances rb
3453: , pay_defined_balances db
3454: , pay_payroll_actions pa
3455: , pay_assignment_actions aa
3456: , pay_defined_balances db2
3457: , pay_fr_contribution_usages fcu
3458: , pay_input_values_f piv

Line 3580: ,pay_payroll_actions run_payact

3576: from pay_run_result_values prrv
3577: ,pay_run_results prr
3578: ,pay_element_types_f pet
3579: ,pay_input_values_f_tl piv
3580: ,pay_payroll_actions run_payact
3581: ,pay_assignment_actions run_assact
3582: ,pay_action_interlocks arc_lock
3583: ,pay_action_interlocks pre_lock
3584: ,pay_entry_process_details epd

Line 3586: ,pay_payroll_actions ppa_date

3582: ,pay_action_interlocks arc_lock
3583: ,pay_action_interlocks pre_lock
3584: ,pay_entry_process_details epd
3585: ,per_time_periods ptp_date
3586: ,pay_payroll_actions ppa_date
3587: ,pay_assignment_actions paa_date
3588: where epd.element_entry_id = prr.element_entry_id
3589: and epd.retro_component_id is not null
3590: and prrv.run_result_id = prr.run_result_id