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

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

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

Line 163: FROM pay_payroll_actions

159: , 'RETROACTIVE_PAYMENT_TO'
160: )
161: )) L_RETROACTIVE_PAYMENT_TO
162: , effective_date, business_group_id bg_id
163: FROM pay_payroll_actions
164: WHERE payroll_action_id = p_payroll_action_id;
165:
166: lr_parameter_info csr_parameter_info%ROWTYPE;
167: l_proc VARCHAR2 (240)

Line 479: pay_payroll_actions.payroll_action_id%type)

475: AND ue.business_group_id is NULL
476: AND ue.creator_type = 'B';
477:
478: CURSOR csr_assignment_action (csr_v_payroll_action_id
479: pay_payroll_actions.payroll_action_id%type)
480: IS
481: SELECT MAX(assignment_action_id)
482: FROM pay_Assignment_actions WHERE
483: payroll_action_id=csr_v_payroll_action_id; --23

Line 642: ,pay_payroll_actions ppa

638:
639: p_sql :=
640: 'SELECT DISTINCT person_id
641: FROM per_people_f ppf
642: ,pay_payroll_actions ppa
643: WHERE ppa.payroll_action_id = :payroll_action_id
644: AND ppa.business_group_id = ppf.business_group_id
645: ORDER BY ppf.person_id';
646: g_payroll_action_id := p_payroll_action_id;

Line 1017: pay_payroll_actions.payroll_action_id%type)

1013: AND ue.business_group_id is NULL
1014: AND ue.creator_type = 'B';
1015:
1016: CURSOR csr_assignment_action (csr_v_payroll_action_id
1017: pay_payroll_actions.payroll_action_id%type)
1018: IS
1019: SELECT MAX(assignment_action_id)
1020: FROM pay_Assignment_actions WHERE
1021: payroll_action_id=csr_v_payroll_action_id; --23

Line 1066: pay_payroll_actions ppa,

1062: csr_v_element_type_id number, csr_v_input_value_id number)
1063: IS
1064: SELECT SUM(RESULT_VALUE) total --prrv1.* ,paa.assignment_id
1065: FROM pay_assignment_actions paa,
1066: pay_payroll_actions ppa,
1067: pay_run_results prr,
1068: pay_run_result_values prrv1,
1069: pay_input_values_f pivf,
1070: pay_element_types_f petf

Line 3664: pay_payroll_actions ppa,

3660: pai1.ACTION_INFORMATION11 Terminated,
3661: pai1.ACTION_INFORMATION12 Painter*/
3662: /*FROM
3663: pay_action_information pai,
3664: pay_payroll_actions ppa,
3665: pay_action_information pai1
3666: WHERE
3667: pai.action_context_id = ppa.payroll_action_id
3668: AND ppa.payroll_action_id =p_payroll_action_id --27021 --20162 --20264 --20165

Line 3700: pay_payroll_actions ppa,

3696: pai1.ACTION_INFORMATION11 Terminated,
3697: pai1.ACTION_INFORMATION12 Painter*/
3698: /*FROM
3699: pay_action_information pai,
3700: pay_payroll_actions ppa,
3701: pay_action_information pai1
3702: WHERE
3703: pai.action_context_id = ppa.payroll_action_id
3704: AND ppa.payroll_action_id =p_payroll_action_id --27021 --20162 --20264 --20165

Line 3732: pay_payroll_actions ppa,

3728: pai1.ACTION_INFORMATION12 Terminated,
3729: pai1.ACTION_INFORMATION13 Painter
3730: FROM
3731: --pay_action_information pai,
3732: pay_payroll_actions ppa,
3733: pay_action_information pai1
3734: WHERE
3735: pai1.action_context_id = ppa.payroll_action_id
3736: AND ppa.payroll_action_id =p_payroll_action_id --27021 --20162 --20264 --20165

Line 3813: pay_payroll_actions ppa,

3809: decode(pai5.action_information18,0,NULL,pai5.action_information18) wh_sick_pay,
3810: decode(pai5.action_information19,0,NULL,pai5.action_information19) wh_total_employees
3811: FROM
3812: pay_action_information pai,
3813: pay_payroll_actions ppa,
3814: pay_action_information pai1,
3815: pay_action_information pai2,
3816: pay_action_information pai3,
3817: pay_action_information pai4,

Line 3869: pay_payroll_actions ppa

3865: fnd_date.canonical_to_date(pai.action_information10) retroactive_date_to
3866: FROM
3867: pay_action_information pai,
3868: pay_action_information pai1,
3869: pay_payroll_actions ppa
3870: WHERE
3871: ppa.payroll_action_id=csr_v_payroll_action_id
3872: AND ppa.payroll_action_id=pai.action_context_id
3873: AND pai.action_context_id=pai1.action_context_id

Line 3899: pay_payroll_actions ppa

3895: decode(sum(pai2.action_information19),0,NULL,sum(pai2.action_information19)) bh_total_employees
3896: FROM
3897: pay_action_information pai1,
3898: pay_action_information pai2,
3899: pay_payroll_actions ppa
3900: WHERE
3901: ppa.payroll_action_id=csr_v_payroll_action_id
3902: AND ppa.payroll_action_id=pai1.action_context_id
3903: AND pai1.action_context_id=pai2.action_context_id

Line 3921: pay_payroll_actions ppa

3917: IS SELECT pai2.action_information4 bh_worked_calendar_month
3918: FROM
3919: pay_action_information pai1,
3920: pay_action_information pai2,
3921: pay_payroll_actions ppa
3922: WHERE
3923: ppa.payroll_action_id=csr_v_payroll_action_id
3924: AND ppa.payroll_action_id=pai1.action_context_id
3925: AND pai1.action_context_id=pai2.action_context_id

Line 3955: pay_payroll_actions ppa

3951: decode(sum(pai3.action_information19),0,NULL,sum(pai3.action_information19)) bs_total_employees
3952: FROM
3953: pay_action_information pai1,
3954: pay_action_information pai3,
3955: pay_payroll_actions ppa
3956: WHERE
3957: ppa.payroll_action_id=csr_v_payroll_action_id
3958: AND ppa.payroll_action_id=pai1.action_context_id
3959: AND pai1.action_context_id=pai3.action_context_id

Line 3989: pay_payroll_actions ppa

3985: decode(sum(pai4.action_information19),0,NULL,sum(pai4.action_information19)) ws_total_employees
3986: FROM
3987: pay_action_information pai1,
3988: pay_action_information pai4,
3989: pay_payroll_actions ppa
3990: WHERE
3991: ppa.payroll_action_id=csr_v_payroll_action_id
3992: AND ppa.payroll_action_id=pai1.action_context_id
3993: AND pai1.action_context_id=pai4.action_context_id

Line 4020: pay_payroll_actions ppa

4016: decode(sum(pai5.action_information19),0,NULL,sum(pai5.action_information19)) wh_total_employees
4017: FROM
4018: pay_action_information pai1,
4019: pay_action_information pai5,
4020: pay_payroll_actions ppa
4021: WHERE
4022: ppa.payroll_action_id=csr_v_payroll_action_id
4023: AND ppa.payroll_action_id=pai1.action_context_id
4024: AND pai1.action_context_id=pai5.action_context_id

Line 4087: FROM pay_payroll_actions ppa,

4083: IF p_payroll_action_id IS NULL THEN
4084: BEGIN
4085: SELECT payroll_action_id
4086: INTO l_payroll_action_id
4087: FROM pay_payroll_actions ppa,
4088: fnd_conc_req_summary_v fcrs,
4089: fnd_conc_req_summary_v fcrs1
4090: WHERE fcrs.request_id = fnd_global.conc_request_id
4091: AND fcrs.priority_request_id = fcrs1.priority_request_id