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 418: ,pay_payroll_actions ppa

414: CLOSE csr_get_element;
415:
416: p_sql := 'SELECT DISTINCT person_id
417: FROM per_people_f ppf
418: ,pay_payroll_actions ppa
419: WHERE ppa.payroll_action_id = :payroll_action_id
420: AND ppa.business_group_id = ppf.business_group_id
421: ORDER BY ppf.person_id';
422:

Line 459: FROM pay_payroll_actions ppa,

455: IS
456: SELECT act.assignment_id assignment_id,
457: act.assignment_action_id run_action_id,
458: act1.assignment_action_id prepaid_action_id
459: FROM pay_payroll_actions ppa,
460: pay_payroll_actions appa,
461: pay_payroll_actions appa2,
462: pay_assignment_actions act,
463: pay_assignment_actions act1,

Line 460: pay_payroll_actions appa,

456: SELECT act.assignment_id assignment_id,
457: act.assignment_action_id run_action_id,
458: act1.assignment_action_id prepaid_action_id
459: FROM pay_payroll_actions ppa,
460: pay_payroll_actions appa,
461: pay_payroll_actions appa2,
462: pay_assignment_actions act,
463: pay_assignment_actions act1,
464: pay_action_interlocks pai,

Line 461: pay_payroll_actions appa2,

457: act.assignment_action_id run_action_id,
458: act1.assignment_action_id prepaid_action_id
459: FROM pay_payroll_actions ppa,
460: pay_payroll_actions appa,
461: pay_payroll_actions appa2,
462: pay_assignment_actions act,
463: pay_assignment_actions act1,
464: pay_action_interlocks pai,
465: per_all_assignments_f as1

Line 487: pay_payroll_actions appa3

483:
484: AND NOT EXISTS (SELECT /* + ORDERED */ NULL
485: FROM pay_action_interlocks pai1,
486: pay_assignment_actions act2,
487: pay_payroll_actions appa3
488: WHERE pai1.locked_action_id = act.assignment_action_id
489: AND act2.assignment_action_id= pai1.locking_action_id
490: AND act2.payroll_action_id = appa3.payroll_action_id
491: AND appa3.action_type = 'X'

Line 498: pay_payroll_actions appa3

494:
495: AND NOT EXISTS ( SELECT /* + ORDERED */ NULL
496: FROM pay_action_interlocks pai1,
497: pay_assignment_actions act2,
498: pay_payroll_actions appa3
499: WHERE pai1.locked_action_id = act.assignment_action_id
500: AND act2.assignment_action_id= pai1.locking_action_id
501: AND act2.payroll_action_id = appa3.payroll_action_id
502: AND appa3.action_type = 'V'

Line 605: ,pay_payroll_actions prepay_payact

601: SELECT distinct prepay_payact.payroll_action_id prepay_payact_id
602: ,run_payact.date_earned date_earned
603: FROM pay_action_interlocks archive_intlck
604: ,pay_assignment_actions prepay_assact
605: ,pay_payroll_actions prepay_payact
606: ,pay_action_interlocks prepay_intlck
607: ,pay_assignment_actions run_assact
608: ,pay_payroll_actions run_payact
609: ,pay_assignment_actions archive_assact

Line 608: ,pay_payroll_actions run_payact

604: ,pay_assignment_actions prepay_assact
605: ,pay_payroll_actions prepay_payact
606: ,pay_action_interlocks prepay_intlck
607: ,pay_assignment_actions run_assact
608: ,pay_payroll_actions run_payact
609: ,pay_assignment_actions archive_assact
610: WHERE archive_intlck.locking_action_id = archive_assact.assignment_action_id
611: and archive_assact.payroll_action_id = p_payroll_action_id
612: AND prepay_assact.assignment_action_id = archive_intlck.locked_action_id

Line 630: ,pay_payroll_actions prepay_payact

626: ,run_payact.date_earned date_earned
627: ,run_payact.payroll_action_id run_payact_id
628: FROM pay_action_interlocks archive_intlck
629: ,pay_assignment_actions prepay_assact
630: ,pay_payroll_actions prepay_payact
631: ,pay_action_interlocks prepay_intlck
632: ,pay_assignment_actions run_assact
633: ,pay_payroll_actions run_payact
634: ,pay_assignment_actions archive_assact

Line 633: ,pay_payroll_actions run_payact

629: ,pay_assignment_actions prepay_assact
630: ,pay_payroll_actions prepay_payact
631: ,pay_action_interlocks prepay_intlck
632: ,pay_assignment_actions run_assact
633: ,pay_payroll_actions run_payact
634: ,pay_assignment_actions archive_assact
635: WHERE archive_intlck.locking_action_id = archive_assact.assignment_action_id
636: and archive_assact.payroll_action_id = p_payroll_action_id
637: AND prepay_assact.assignment_action_id = archive_intlck.locked_action_id

Line 1888: ,pay_payroll_actions ppa

1884: ,pay_element_types_f pet
1885: ,pay_element_links_f pel
1886: ,pay_element_entries_f pee
1887: ,pay_assignment_actions paa
1888: ,pay_payroll_actions ppa
1889: WHERE pet.element_type_id = pap.accrual_plan_element_type_id
1890: AND pel.element_type_id = pet.element_type_id
1891: AND pee.element_link_id = pel.element_link_id
1892: AND paa.assignment_id = pee.assignment_id

Line 2049: ,pay_payroll_actions ppa

2045: SELECT rrv.result_value,rr.element_entry_id
2046: FROM pay_run_result_values rrv
2047: ,pay_run_results rr
2048: ,pay_assignment_actions paa
2049: ,pay_payroll_actions ppa
2050: WHERE rrv.input_value_id = p_iv_id
2051: AND rr.element_type_id = p_ele_type_id
2052: AND rr.run_result_id = rrv.run_result_id
2053: AND rr.assignment_action_id = paa.assignment_action_id

Line 2070: ,pay_payroll_actions ppa

2066: SELECT rrv.result_value
2067: FROM pay_run_result_values rrv
2068: ,pay_run_results rr
2069: ,pay_assignment_actions paa
2070: ,pay_payroll_actions ppa
2071: WHERE rrv.input_value_id = p_iv_id
2072: AND rr.element_type_id = p_ele_type_id
2073: AND rr.run_result_id = rrv.run_result_id
2074: AND rr.assignment_action_id = paa.assignment_action_id

Line 2104: ,pay_payroll_actions ppa

2100: ,rrv.result_value UNIT_PRICE
2101: FROM pay_run_result_values rrv
2102: ,pay_run_results rr
2103: ,pay_assignment_actions paa
2104: ,pay_payroll_actions ppa
2105: WHERE rrv.input_value_id = p_iv_id
2106: AND rr.element_type_id = p_ele_type_id
2107: AND rr.run_result_id = rrv.run_result_id
2108: AND rr.assignment_action_id = paa.assignment_action_id

Line 2131: ,pay_payroll_actions ppa

2127: sum(fnd_number.canonical_to_number(rrv2.result_value)) AMOUNT
2128: FROM pay_run_result_values rrv1
2129: ,pay_run_results rr1
2130: ,pay_assignment_actions paa
2131: ,pay_payroll_actions ppa
2132: ,pay_run_result_values rrv2
2133: ,pay_run_results rr2
2134: ,pay_run_result_values rrv3
2135: ,pay_run_results rr3

Line 2166: ,pay_payroll_actions ppa

2162: SELECT rrv3.result_value UNIT_PRICE , rrv1.result_value UNIT, rrv2.result_value AMOUNT
2163: FROM pay_run_result_values rrv1
2164: ,pay_run_results rr1
2165: ,pay_assignment_actions paa
2166: ,pay_payroll_actions ppa
2167: ,pay_run_result_values rrv2
2168: ,pay_run_results rr2
2169: ,pay_run_result_values rrv3
2170: ,pay_run_results rr3

Line 2841: ,pay_payroll_actions prepay_payact

2837: ,run_payact.payroll_action_id run_payact_id
2838: ,run_payact.payroll_id payroll_id
2839: FROM pay_action_interlocks archive_intlck
2840: ,pay_assignment_actions prepay_assact
2841: ,pay_payroll_actions prepay_payact
2842: ,pay_action_interlocks prepay_intlck
2843: ,pay_assignment_actions run_assact
2844: ,pay_payroll_actions run_payact
2845: WHERE archive_intlck.locking_action_id = p_locking_action_id

Line 2844: ,pay_payroll_actions run_payact

2840: ,pay_assignment_actions prepay_assact
2841: ,pay_payroll_actions prepay_payact
2842: ,pay_action_interlocks prepay_intlck
2843: ,pay_assignment_actions run_assact
2844: ,pay_payroll_actions run_payact
2845: WHERE archive_intlck.locking_action_id = p_locking_action_id
2846: AND prepay_assact.assignment_action_id = archive_intlck.locked_action_id
2847: AND prepay_payact.payroll_action_id = prepay_assact.payroll_action_id
2848: AND prepay_payact.action_type IN ('U','P')

Line 2864: ,pay_payroll_actions ppa

2860: ppa.date_earned date_earned,
2861: ppa.effective_date effective_date,
2862: ptp.start_date start_date
2863: FROM per_time_periods ptp
2864: ,pay_payroll_actions ppa
2865: ,pay_assignment_actions paa
2866: WHERE ptp.payroll_id =ppa.payroll_id
2867: AND ppa.payroll_action_id =paa.payroll_action_id
2868: AND paa.assignment_action_id =p_assact_id

Line 2885: l_date_earned pay_payroll_actions.date_earned%TYPE;

2881: l_end_date per_time_periods.end_date%TYPE;
2882: l_pre_end_date per_time_periods.end_date%TYPE;
2883: l_reg_payment_date per_time_periods.regular_payment_date%TYPE;
2884: l_pre_reg_payment_date per_time_periods.regular_payment_date%TYPE;
2885: l_date_earned pay_payroll_actions.date_earned%TYPE;
2886: l_pre_date_earned pay_payroll_actions.date_earned%TYPE;
2887: l_effective_date pay_payroll_actions.effective_date%TYPE;
2888: l_pre_effective_date pay_payroll_actions.effective_date%TYPE;
2889: l_run_payact_id NUMBER;

Line 2886: l_pre_date_earned pay_payroll_actions.date_earned%TYPE;

2882: l_pre_end_date per_time_periods.end_date%TYPE;
2883: l_reg_payment_date per_time_periods.regular_payment_date%TYPE;
2884: l_pre_reg_payment_date per_time_periods.regular_payment_date%TYPE;
2885: l_date_earned pay_payroll_actions.date_earned%TYPE;
2886: l_pre_date_earned pay_payroll_actions.date_earned%TYPE;
2887: l_effective_date pay_payroll_actions.effective_date%TYPE;
2888: l_pre_effective_date pay_payroll_actions.effective_date%TYPE;
2889: l_run_payact_id NUMBER;
2890: l_action_context_id NUMBER;

Line 2887: l_effective_date pay_payroll_actions.effective_date%TYPE;

2883: l_reg_payment_date per_time_periods.regular_payment_date%TYPE;
2884: l_pre_reg_payment_date per_time_periods.regular_payment_date%TYPE;
2885: l_date_earned pay_payroll_actions.date_earned%TYPE;
2886: l_pre_date_earned pay_payroll_actions.date_earned%TYPE;
2887: l_effective_date pay_payroll_actions.effective_date%TYPE;
2888: l_pre_effective_date pay_payroll_actions.effective_date%TYPE;
2889: l_run_payact_id NUMBER;
2890: l_action_context_id NUMBER;
2891: g_archive_pact NUMBER;

Line 2888: l_pre_effective_date pay_payroll_actions.effective_date%TYPE;

2884: l_pre_reg_payment_date per_time_periods.regular_payment_date%TYPE;
2885: l_date_earned pay_payroll_actions.date_earned%TYPE;
2886: l_pre_date_earned pay_payroll_actions.date_earned%TYPE;
2887: l_effective_date pay_payroll_actions.effective_date%TYPE;
2888: l_pre_effective_date pay_payroll_actions.effective_date%TYPE;
2889: l_run_payact_id NUMBER;
2890: l_action_context_id NUMBER;
2891: g_archive_pact NUMBER;
2892: p_assactid NUMBER;

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

2950: ,p_effective_date => p_effective_date);
2951: */
2952:
2953: -- using l_date_earned (Payroll Run Date Earned) instead of l_pre_date_earned (Prepayments Date Earned)
2954: -- because the date_earned column at table pay_payroll_actions for Prepayments may not always be populated.
2955:
2956: ARCHIVE_EMPLOYEE_DETAILS(p_archive_assact_id => p_assignment_action_id
2957: ,p_assignment_id => rec_archive_ids.run_assgt_id
2958: ,p_assignment_action_id => rec_archive_ids.run_assact_id

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

2986: p_effective_date => p_effective_date);
2987: */
2988:
2989: -- using l_date_earned (Payroll Run Date Earned) instead of l_pre_date_earned (Prepayments Date Earned)
2990: -- because the date_earned column at table pay_payroll_actions for Prepayments may not always be populated.
2991:
2992: ARCHIVE_PAYMENT_INFO(p_archive_assact_id => p_assignment_action_id,
2993: p_prepay_assact_id => rec_archive_ids.prepay_assact_id,
2994: p_assignment_id => rec_archive_ids.prepay_assgt_id,

Line 3165: FROM pay_payroll_actions

3161: -------------
3162: /* cursor to get the payroll_d */
3163: CURSOR csr_payroll (p_payroll_action_id NUMBER) IS
3164: SELECT PAY_DK_ARCHIVE.GET_PARAMETER(legislative_parameters,'PAYROLL_ID')
3165: FROM pay_payroll_actions
3166: WHERE payroll_action_id = p_payroll_action_id ;
3167:
3168:
3169: /* cursor to get the payroll details */

Line 3714: ,pay_payroll_actions ppa

3710: , rr.run_result_id run_result_id
3711: FROM pay_run_result_values rrv
3712: ,pay_run_results rr
3713: ,pay_assignment_actions paa
3714: ,pay_payroll_actions ppa
3715: WHERE rrv.input_value_id = p_iv_id
3716: AND rr.element_type_id = p_ele_type_id
3717: AND rr.run_result_id = rrv.run_result_id
3718: AND rr.assignment_action_id = paa.assignment_action_id

Line 3788: ,pay_payroll_actions ppa

3784: SELECT rrv.result_value
3785: FROM pay_run_result_values rrv
3786: ,pay_run_results rr
3787: ,pay_assignment_actions paa
3788: ,pay_payroll_actions ppa
3789: WHERE rrv.input_value_id = p_iv_id
3790: AND rr.element_type_id = p_ele_type_id
3791: AND rr.run_result_id = rrv.run_result_id
3792: AND rr.assignment_action_id = paa.assignment_action_id

Line 3811: ,pay_payroll_actions ppa

3807: ,rrv.result_value UNIT_PRICE
3808: FROM pay_run_result_values rrv
3809: ,pay_run_results rr
3810: ,pay_assignment_actions paa
3811: ,pay_payroll_actions ppa
3812: WHERE rrv.input_value_id = p_iv_id
3813: AND rr.element_type_id = p_ele_type_id
3814: AND rr.run_result_id = rrv.run_result_id
3815: AND rr.assignment_action_id = paa.assignment_action_id

Line 3838: ,pay_payroll_actions ppa

3834: sum(fnd_number.canonical_to_number(rrv2.result_value)) AMOUNT
3835: FROM pay_run_result_values rrv1
3836: ,pay_run_results rr1
3837: ,pay_assignment_actions paa
3838: ,pay_payroll_actions ppa
3839: ,pay_run_result_values rrv2
3840: ,pay_run_results rr2
3841: ,pay_run_result_values rrv3
3842: ,pay_run_results rr3

Line 3874: ,pay_payroll_actions ppa

3870: rrv2.result_value AMOUNT
3871: FROM pay_run_result_values rrv1
3872: ,pay_run_results rr1
3873: ,pay_assignment_actions paa
3874: ,pay_payroll_actions ppa
3875: ,pay_run_result_values rrv2
3876: ,pay_run_results rr2
3877: ,pay_run_result_values rrv3
3878: ,pay_run_results rr3