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

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

51: ,p_token IN VARCHAR2
52: ,p_segment_number IN NUMBER default NULL ) RETURN VARCHAR2
53: IS
54:
55: l_parameter pay_payroll_actions.legislative_parameters%TYPE:=NULL;
56: l_start_pos NUMBER;
57: l_delimiter VARCHAR2(1):=' ';
58: l_proc VARCHAR2(40):= g_package||' get parameter ';
59:

Line 116: FROM pay_payroll_actions

112: ,PAY_AE_ARCHIVE.GET_PARAMETER(legislative_parameters,'START_DATE')
113: ,PAY_AE_ARCHIVE.GET_PARAMETER(legislative_parameters,'END_DATE')
114: ,effective_date
115: ,business_group_id
116: FROM pay_payroll_actions
117: WHERE payroll_action_id = p_payroll_action_id;
118: l_proc VARCHAR2(240):= g_package||' GET_ALL_PARAMETERS ';
119: --
120: BEGIN

Line 167: ,pay_payroll_actions ppa

163: ppa.effective_date pay_date,
164: ptp.period_name period_name,
165: ppf.payroll_name payroll_name
166: FROM per_time_periods ptp
167: ,pay_payroll_actions ppa
168: ,pay_payrolls_f ppf
169: WHERE ptp.payroll_id = ppa.payroll_id
170: AND ppa.payroll_action_id = p_run_payact_id
171: AND ppa.payroll_id = ppf.payroll_id

Line 404: ,pay_payroll_actions ppa

400:
401:
402: p_sql := 'SELECT DISTINCT person_id
403: FROM per_people_f ppf
404: ,pay_payroll_actions ppa
405: WHERE ppa.payroll_action_id = :payroll_action_id
406: AND ppa.business_group_id = ppf.business_group_id
407: ORDER BY ppf.person_id';
408:

Line 440: FROM pay_payroll_actions ppa,

436: IS
437: SELECT act.assignment_id assignment_id,
438: act.assignment_action_id run_action_id,
439: act1.assignment_action_id prepaid_action_id
440: FROM pay_payroll_actions ppa,
441: pay_payroll_actions appa,
442: pay_payroll_actions appa2,
443: pay_assignment_actions act,
444: pay_assignment_actions act1,

Line 441: pay_payroll_actions appa,

437: SELECT act.assignment_id assignment_id,
438: act.assignment_action_id run_action_id,
439: act1.assignment_action_id prepaid_action_id
440: FROM pay_payroll_actions ppa,
441: pay_payroll_actions appa,
442: pay_payroll_actions appa2,
443: pay_assignment_actions act,
444: pay_assignment_actions act1,
445: pay_action_interlocks pai,

Line 442: pay_payroll_actions appa2,

438: act.assignment_action_id run_action_id,
439: act1.assignment_action_id prepaid_action_id
440: FROM pay_payroll_actions ppa,
441: pay_payroll_actions appa,
442: pay_payroll_actions appa2,
443: pay_assignment_actions act,
444: pay_assignment_actions act1,
445: pay_action_interlocks pai,
446: per_all_assignments_f as1

Line 473: pay_payroll_actions appa3

469: AND (as1.payroll_id = p_payroll_id OR p_payroll_id IS NULL)
470: AND NOT EXISTS (SELECT /* + ORDERED */ NULL
471: FROM pay_action_interlocks pai1,
472: pay_assignment_actions act2,
473: pay_payroll_actions appa3
474: WHERE pai1.locked_action_id = act.assignment_action_id
475: AND act2.assignment_action_id= pai1.locking_action_id
476: AND act2.payroll_action_id = appa3.payroll_action_id
477: AND appa3.action_type = 'X'

Line 483: pay_payroll_actions appa3

479: AND appa3.report_type = 'AE_ARCHIVE')
480: AND NOT EXISTS ( SELECT /* + ORDERED */ NULL
481: FROM pay_action_interlocks pai1,
482: pay_assignment_actions act2,
483: pay_payroll_actions appa3
484: WHERE pai1.locked_action_id = act.assignment_action_id
485: AND act2.assignment_action_id= pai1.locking_action_id
486: AND act2.payroll_action_id = appa3.payroll_action_id
487: AND appa3.action_type = 'V'

Line 593: ,pay_payroll_actions prepay_payact

589: SELECT distinct prepay_payact.payroll_action_id prepay_payact_id
590: ,run_payact.date_earned date_earned
591: FROM pay_action_interlocks archive_intlck
592: ,pay_assignment_actions prepay_assact
593: ,pay_payroll_actions prepay_payact
594: ,pay_action_interlocks prepay_intlck
595: ,pay_assignment_actions run_assact
596: ,pay_payroll_actions run_payact
597: ,pay_assignment_actions archive_assact

Line 596: ,pay_payroll_actions run_payact

592: ,pay_assignment_actions prepay_assact
593: ,pay_payroll_actions prepay_payact
594: ,pay_action_interlocks prepay_intlck
595: ,pay_assignment_actions run_assact
596: ,pay_payroll_actions run_payact
597: ,pay_assignment_actions archive_assact
598: WHERE archive_intlck.locking_action_id = archive_assact.assignment_action_id
599: and archive_assact.payroll_action_id = p_payroll_action_id
600: AND prepay_assact.assignment_action_id = archive_intlck.locked_action_id

Line 616: ,pay_payroll_actions prepay_payact

612: ,run_payact.date_earned date_earned
613: ,run_payact.payroll_action_id run_payact_id
614: FROM pay_action_interlocks archive_intlck
615: ,pay_assignment_actions prepay_assact
616: ,pay_payroll_actions prepay_payact
617: ,pay_action_interlocks prepay_intlck
618: ,pay_assignment_actions run_assact
619: ,pay_payroll_actions run_payact
620: ,pay_assignment_actions archive_assact

Line 619: ,pay_payroll_actions run_payact

615: ,pay_assignment_actions prepay_assact
616: ,pay_payroll_actions prepay_payact
617: ,pay_action_interlocks prepay_intlck
618: ,pay_assignment_actions run_assact
619: ,pay_payroll_actions run_payact
620: ,pay_assignment_actions archive_assact
621: WHERE archive_intlck.locking_action_id = archive_assact.assignment_action_id
622: and archive_assact.payroll_action_id = p_payroll_action_id
623: AND prepay_assact.assignment_action_id = archive_intlck.locked_action_id

Line 1540: ,pay_payroll_actions ppa

1536: ,rr.run_result_id /*Added for loan*/
1537: FROM pay_run_result_values rrv
1538: ,pay_run_results rr
1539: ,pay_assignment_actions paa
1540: ,pay_payroll_actions ppa
1541: WHERE rrv.input_value_id = p_iv_id
1542: AND rr.element_type_id = p_ele_type_id
1543: AND rr.run_result_id = rrv.run_result_id
1544: AND rr.assignment_action_id = paa.assignment_action_id

Line 2038: ,pay_payroll_actions ppa

2034: SELECT rrv.result_value
2035: FROM pay_run_result_values rrv
2036: ,pay_run_results rr
2037: ,pay_assignment_actions paa
2038: ,pay_payroll_actions ppa
2039: WHERE rrv.input_value_id = p_iv_id
2040: AND rr.element_type_id = p_ele_type_id
2041: AND rr.run_result_id = rrv.run_result_id
2042: AND rr.assignment_action_id = paa.assignment_action_id

Line 2324: ,pay_payroll_actions prepay_payact

2320: ,run_payact.payroll_action_id run_payact_id
2321: ,run_payact.payroll_id payroll_id
2322: FROM pay_action_interlocks archive_intlck
2323: ,pay_assignment_actions prepay_assact
2324: ,pay_payroll_actions prepay_payact
2325: ,pay_action_interlocks prepay_intlck
2326: ,pay_assignment_actions run_assact
2327: ,pay_payroll_actions run_payact
2328: WHERE archive_intlck.locking_action_id = p_locking_action_id

Line 2327: ,pay_payroll_actions run_payact

2323: ,pay_assignment_actions prepay_assact
2324: ,pay_payroll_actions prepay_payact
2325: ,pay_action_interlocks prepay_intlck
2326: ,pay_assignment_actions run_assact
2327: ,pay_payroll_actions run_payact
2328: WHERE archive_intlck.locking_action_id = p_locking_action_id
2329: AND prepay_assact.assignment_action_id = archive_intlck.locked_action_id
2330: AND prepay_payact.payroll_action_id = prepay_assact.payroll_action_id
2331: AND prepay_payact.action_type IN ('U','P')

Line 2347: ,pay_payroll_actions ppa

2343: ppa.date_earned date_earned,
2344: ppa.effective_date effective_date,
2345: ptp.start_date start_date
2346: FROM per_time_periods ptp
2347: ,pay_payroll_actions ppa
2348: ,pay_assignment_actions paa
2349: WHERE ptp.payroll_id =ppa.payroll_id
2350: AND ppa.payroll_action_id =paa.payroll_action_id
2351: AND paa.assignment_action_id =p_assact_id

Line 2370: l_date_earned pay_payroll_actions.date_earned%TYPE;

2366: l_end_date per_time_periods.end_date%TYPE;
2367: l_pre_end_date per_time_periods.end_date%TYPE;
2368: l_reg_payment_date per_time_periods.regular_payment_date%TYPE;
2369: l_pre_reg_payment_date per_time_periods.regular_payment_date%TYPE;
2370: l_date_earned pay_payroll_actions.date_earned%TYPE;
2371: l_pre_date_earned pay_payroll_actions.date_earned%TYPE;
2372: l_effective_date pay_payroll_actions.effective_date%TYPE;
2373: l_pre_effective_date pay_payroll_actions.effective_date%TYPE;
2374: l_run_payact_id NUMBER;

Line 2371: l_pre_date_earned pay_payroll_actions.date_earned%TYPE;

2367: l_pre_end_date per_time_periods.end_date%TYPE;
2368: l_reg_payment_date per_time_periods.regular_payment_date%TYPE;
2369: l_pre_reg_payment_date per_time_periods.regular_payment_date%TYPE;
2370: l_date_earned pay_payroll_actions.date_earned%TYPE;
2371: l_pre_date_earned pay_payroll_actions.date_earned%TYPE;
2372: l_effective_date pay_payroll_actions.effective_date%TYPE;
2373: l_pre_effective_date pay_payroll_actions.effective_date%TYPE;
2374: l_run_payact_id NUMBER;
2375: l_action_context_id NUMBER;

Line 2372: l_effective_date pay_payroll_actions.effective_date%TYPE;

2368: l_reg_payment_date per_time_periods.regular_payment_date%TYPE;
2369: l_pre_reg_payment_date per_time_periods.regular_payment_date%TYPE;
2370: l_date_earned pay_payroll_actions.date_earned%TYPE;
2371: l_pre_date_earned pay_payroll_actions.date_earned%TYPE;
2372: l_effective_date pay_payroll_actions.effective_date%TYPE;
2373: l_pre_effective_date pay_payroll_actions.effective_date%TYPE;
2374: l_run_payact_id NUMBER;
2375: l_action_context_id NUMBER;
2376: g_archive_pact NUMBER;

Line 2373: l_pre_effective_date pay_payroll_actions.effective_date%TYPE;

2369: l_pre_reg_payment_date per_time_periods.regular_payment_date%TYPE;
2370: l_date_earned pay_payroll_actions.date_earned%TYPE;
2371: l_pre_date_earned pay_payroll_actions.date_earned%TYPE;
2372: l_effective_date pay_payroll_actions.effective_date%TYPE;
2373: l_pre_effective_date pay_payroll_actions.effective_date%TYPE;
2374: l_run_payact_id NUMBER;
2375: l_action_context_id NUMBER;
2376: g_archive_pact NUMBER;
2377: p_assactid NUMBER;