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

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

59: ,p_token IN VARCHAR2
60: ,p_segment_number IN NUMBER default NULL ) RETURN VARCHAR2
61: IS
62:
63: l_parameter pay_payroll_actions.legislative_parameters%TYPE:=NULL;
64: l_start_pos NUMBER;
65: l_delimiter VARCHAR2(1):=' ';
66: l_proc VARCHAR2(40):= g_package||' get parameter ';
67:

Line 122: FROM pay_payroll_actions

118: ,PAY_DK_ARCHIVE.GET_PARAMETER(legislative_parameters,'START_DATE')
119: ,PAY_DK_ARCHIVE.GET_PARAMETER(legislative_parameters,'END_DATE')
120: ,effective_date
121: ,business_group_id
122: FROM pay_payroll_actions
123: WHERE payroll_action_id = p_payroll_action_id;
124:
125: l_proc VARCHAR2(240):= g_package||' GET_ALL_PARAMETERS ';
126: --

Line 197: ,pay_payroll_actions ppa

193: ptp.start_date start_date,
194: ptp.period_name period_name,
195: ppf.payroll_name payroll_name
196: FROM per_time_periods ptp
197: ,pay_payroll_actions ppa
198: ,pay_payrolls_f ppf
199: WHERE ptp.payroll_id = ppa.payroll_id
200: AND ppa.payroll_action_id = p_run_payact_id
201: AND ppa.payroll_id = ppf.payroll_id

Line 411: ,pay_payroll_actions ppa

407: CLOSE csr_get_element;
408:
409: p_sql := 'SELECT DISTINCT person_id
410: FROM per_people_f ppf
411: ,pay_payroll_actions ppa
412: WHERE ppa.payroll_action_id = :payroll_action_id
413: AND ppa.business_group_id = ppf.business_group_id
414: ORDER BY ppf.person_id';
415:

Line 452: FROM pay_payroll_actions ppa,

448: IS
449: SELECT act.assignment_id assignment_id,
450: act.assignment_action_id run_action_id,
451: act1.assignment_action_id prepaid_action_id
452: FROM pay_payroll_actions ppa,
453: pay_payroll_actions appa,
454: pay_payroll_actions appa2,
455: pay_assignment_actions act,
456: pay_assignment_actions act1,

Line 453: pay_payroll_actions appa,

449: SELECT act.assignment_id assignment_id,
450: act.assignment_action_id run_action_id,
451: act1.assignment_action_id prepaid_action_id
452: FROM pay_payroll_actions ppa,
453: pay_payroll_actions appa,
454: pay_payroll_actions appa2,
455: pay_assignment_actions act,
456: pay_assignment_actions act1,
457: pay_action_interlocks pai,

Line 454: pay_payroll_actions appa2,

450: act.assignment_action_id run_action_id,
451: act1.assignment_action_id prepaid_action_id
452: FROM pay_payroll_actions ppa,
453: pay_payroll_actions appa,
454: pay_payroll_actions appa2,
455: pay_assignment_actions act,
456: pay_assignment_actions act1,
457: pay_action_interlocks pai,
458: per_all_assignments_f as1

Line 480: pay_payroll_actions appa3

476:
477: AND NOT EXISTS (SELECT /* + ORDERED */ NULL
478: FROM pay_action_interlocks pai1,
479: pay_assignment_actions act2,
480: pay_payroll_actions appa3
481: WHERE pai1.locked_action_id = act.assignment_action_id
482: AND act2.assignment_action_id= pai1.locking_action_id
483: AND act2.payroll_action_id = appa3.payroll_action_id
484: AND appa3.action_type = 'X'

Line 491: pay_payroll_actions appa3

487:
488: AND NOT EXISTS ( SELECT /* + ORDERED */ NULL
489: FROM pay_action_interlocks pai1,
490: pay_assignment_actions act2,
491: pay_payroll_actions appa3
492: WHERE pai1.locked_action_id = act.assignment_action_id
493: AND act2.assignment_action_id= pai1.locking_action_id
494: AND act2.payroll_action_id = appa3.payroll_action_id
495: AND appa3.action_type = 'V'

Line 598: ,pay_payroll_actions prepay_payact

594: SELECT distinct prepay_payact.payroll_action_id prepay_payact_id
595: ,run_payact.date_earned date_earned
596: FROM pay_action_interlocks archive_intlck
597: ,pay_assignment_actions prepay_assact
598: ,pay_payroll_actions prepay_payact
599: ,pay_action_interlocks prepay_intlck
600: ,pay_assignment_actions run_assact
601: ,pay_payroll_actions run_payact
602: ,pay_assignment_actions archive_assact

Line 601: ,pay_payroll_actions run_payact

597: ,pay_assignment_actions prepay_assact
598: ,pay_payroll_actions prepay_payact
599: ,pay_action_interlocks prepay_intlck
600: ,pay_assignment_actions run_assact
601: ,pay_payroll_actions run_payact
602: ,pay_assignment_actions archive_assact
603: WHERE archive_intlck.locking_action_id = archive_assact.assignment_action_id
604: and archive_assact.payroll_action_id = p_payroll_action_id
605: AND prepay_assact.assignment_action_id = archive_intlck.locked_action_id

Line 623: ,pay_payroll_actions prepay_payact

619: ,run_payact.date_earned date_earned
620: ,run_payact.payroll_action_id run_payact_id
621: FROM pay_action_interlocks archive_intlck
622: ,pay_assignment_actions prepay_assact
623: ,pay_payroll_actions prepay_payact
624: ,pay_action_interlocks prepay_intlck
625: ,pay_assignment_actions run_assact
626: ,pay_payroll_actions run_payact
627: ,pay_assignment_actions archive_assact

Line 626: ,pay_payroll_actions run_payact

622: ,pay_assignment_actions prepay_assact
623: ,pay_payroll_actions prepay_payact
624: ,pay_action_interlocks prepay_intlck
625: ,pay_assignment_actions run_assact
626: ,pay_payroll_actions run_payact
627: ,pay_assignment_actions archive_assact
628: WHERE archive_intlck.locking_action_id = archive_assact.assignment_action_id
629: and archive_assact.payroll_action_id = p_payroll_action_id
630: AND prepay_assact.assignment_action_id = archive_intlck.locked_action_id

Line 1860: ,pay_payroll_actions ppa

1856: ,pay_element_types_f pet
1857: ,pay_element_links_f pel
1858: ,pay_element_entries_f pee
1859: ,pay_assignment_actions paa
1860: ,pay_payroll_actions ppa
1861: WHERE pet.element_type_id = pap.accrual_plan_element_type_id
1862: AND pel.element_type_id = pet.element_type_id
1863: AND pee.element_link_id = pel.element_link_id
1864: AND paa.assignment_id = pee.assignment_id

Line 2021: ,pay_payroll_actions ppa

2017: SELECT rrv.result_value
2018: FROM pay_run_result_values rrv
2019: ,pay_run_results rr
2020: ,pay_assignment_actions paa
2021: ,pay_payroll_actions ppa
2022: WHERE rrv.input_value_id = p_iv_id
2023: AND rr.element_type_id = p_ele_type_id
2024: AND rr.run_result_id = rrv.run_result_id
2025: AND rr.assignment_action_id = paa.assignment_action_id

Line 2399: ,pay_payroll_actions prepay_payact

2395: ,run_payact.payroll_action_id run_payact_id
2396: ,run_payact.payroll_id payroll_id
2397: FROM pay_action_interlocks archive_intlck
2398: ,pay_assignment_actions prepay_assact
2399: ,pay_payroll_actions prepay_payact
2400: ,pay_action_interlocks prepay_intlck
2401: ,pay_assignment_actions run_assact
2402: ,pay_payroll_actions run_payact
2403: WHERE archive_intlck.locking_action_id = p_locking_action_id

Line 2402: ,pay_payroll_actions run_payact

2398: ,pay_assignment_actions prepay_assact
2399: ,pay_payroll_actions prepay_payact
2400: ,pay_action_interlocks prepay_intlck
2401: ,pay_assignment_actions run_assact
2402: ,pay_payroll_actions run_payact
2403: WHERE archive_intlck.locking_action_id = p_locking_action_id
2404: AND prepay_assact.assignment_action_id = archive_intlck.locked_action_id
2405: AND prepay_payact.payroll_action_id = prepay_assact.payroll_action_id
2406: AND prepay_payact.action_type IN ('U','P')

Line 2422: ,pay_payroll_actions ppa

2418: ppa.date_earned date_earned,
2419: ppa.effective_date effective_date,
2420: ptp.start_date start_date
2421: FROM per_time_periods ptp
2422: ,pay_payroll_actions ppa
2423: ,pay_assignment_actions paa
2424: WHERE ptp.payroll_id =ppa.payroll_id
2425: AND ppa.payroll_action_id =paa.payroll_action_id
2426: AND paa.assignment_action_id =p_assact_id

Line 2443: l_date_earned pay_payroll_actions.date_earned%TYPE;

2439: l_end_date per_time_periods.end_date%TYPE;
2440: l_pre_end_date per_time_periods.end_date%TYPE;
2441: l_reg_payment_date per_time_periods.regular_payment_date%TYPE;
2442: l_pre_reg_payment_date per_time_periods.regular_payment_date%TYPE;
2443: l_date_earned pay_payroll_actions.date_earned%TYPE;
2444: l_pre_date_earned pay_payroll_actions.date_earned%TYPE;
2445: l_effective_date pay_payroll_actions.effective_date%TYPE;
2446: l_pre_effective_date pay_payroll_actions.effective_date%TYPE;
2447: l_run_payact_id NUMBER;

Line 2444: l_pre_date_earned pay_payroll_actions.date_earned%TYPE;

2440: l_pre_end_date per_time_periods.end_date%TYPE;
2441: l_reg_payment_date per_time_periods.regular_payment_date%TYPE;
2442: l_pre_reg_payment_date per_time_periods.regular_payment_date%TYPE;
2443: l_date_earned pay_payroll_actions.date_earned%TYPE;
2444: l_pre_date_earned pay_payroll_actions.date_earned%TYPE;
2445: l_effective_date pay_payroll_actions.effective_date%TYPE;
2446: l_pre_effective_date pay_payroll_actions.effective_date%TYPE;
2447: l_run_payact_id NUMBER;
2448: l_action_context_id NUMBER;

Line 2445: l_effective_date pay_payroll_actions.effective_date%TYPE;

2441: l_reg_payment_date per_time_periods.regular_payment_date%TYPE;
2442: l_pre_reg_payment_date per_time_periods.regular_payment_date%TYPE;
2443: l_date_earned pay_payroll_actions.date_earned%TYPE;
2444: l_pre_date_earned pay_payroll_actions.date_earned%TYPE;
2445: l_effective_date pay_payroll_actions.effective_date%TYPE;
2446: l_pre_effective_date pay_payroll_actions.effective_date%TYPE;
2447: l_run_payact_id NUMBER;
2448: l_action_context_id NUMBER;
2449: g_archive_pact NUMBER;

Line 2446: l_pre_effective_date pay_payroll_actions.effective_date%TYPE;

2442: l_pre_reg_payment_date per_time_periods.regular_payment_date%TYPE;
2443: l_date_earned pay_payroll_actions.date_earned%TYPE;
2444: l_pre_date_earned pay_payroll_actions.date_earned%TYPE;
2445: l_effective_date pay_payroll_actions.effective_date%TYPE;
2446: l_pre_effective_date pay_payroll_actions.effective_date%TYPE;
2447: l_run_payact_id NUMBER;
2448: l_action_context_id NUMBER;
2449: g_archive_pact NUMBER;
2450: p_assactid NUMBER;

Line 2512: -- because the date_earned column at table pay_payroll_actions for Prepayments may not always be populated.

2508: ,p_effective_date => p_effective_date);
2509: */
2510:
2511: -- using l_date_earned (Payroll Run Date Earned) instead of l_pre_date_earned (Prepayments Date Earned)
2512: -- because the date_earned column at table pay_payroll_actions for Prepayments may not always be populated.
2513:
2514: ARCHIVE_EMPLOYEE_DETAILS(p_archive_assact_id => p_assignment_action_id
2515: ,p_assignment_id => rec_archive_ids.run_assgt_id
2516: ,p_assignment_action_id => rec_archive_ids.run_assact_id

Line 2548: -- because the date_earned column at table pay_payroll_actions for Prepayments may not always be populated.

2544: p_effective_date => p_effective_date);
2545: */
2546:
2547: -- using l_date_earned (Payroll Run Date Earned) instead of l_pre_date_earned (Prepayments Date Earned)
2548: -- because the date_earned column at table pay_payroll_actions for Prepayments may not always be populated.
2549:
2550: ARCHIVE_PAYMENT_INFO(p_archive_assact_id => p_assignment_action_id,
2551: p_prepay_assact_id => rec_archive_ids.prepay_assact_id,
2552: p_assignment_id => rec_archive_ids.prepay_assgt_id,

Line 2723: FROM pay_payroll_actions

2719: -------------
2720: /* cursor to get the payroll_d */
2721: CURSOR csr_payroll (p_payroll_action_id NUMBER) IS
2722: SELECT PAY_DK_ARCHIVE.GET_PARAMETER(legislative_parameters,'PAYROLL_ID')
2723: FROM pay_payroll_actions
2724: WHERE payroll_action_id = p_payroll_action_id ;
2725:
2726:
2727: /* cursor to get the payroll details */

Line 3240: ,pay_payroll_actions ppa

3236: , rr.run_result_id
3237: FROM pay_run_result_values rrv
3238: ,pay_run_results rr
3239: ,pay_assignment_actions paa
3240: ,pay_payroll_actions ppa
3241: WHERE rrv.input_value_id = p_iv_id
3242: AND rr.element_type_id = p_ele_type_id
3243: AND rr.run_result_id = rrv.run_result_id
3244: AND rr.assignment_action_id = paa.assignment_action_id