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 1016: pay_payroll_actions.payroll_action_id%type)

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

Line 1065: pay_payroll_actions ppa,

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

Line 3663: pay_payroll_actions ppa,

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

Line 3699: pay_payroll_actions ppa,

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

Line 3731: pay_payroll_actions ppa,

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

Line 3812: pay_payroll_actions ppa,

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

Line 3868: pay_payroll_actions ppa

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

Line 3898: pay_payroll_actions ppa

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

Line 3920: pay_payroll_actions ppa

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

Line 3954: pay_payroll_actions ppa

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

Line 3988: pay_payroll_actions ppa

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

Line 4019: pay_payroll_actions ppa

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

Line 4086: FROM pay_payroll_actions ppa,

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