APPS.PAY_SE_FORA dependencies on PAY_PAYROLL_ACTIONS

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

45: , p_segment_number IN NUMBER DEFAULT NULL
46: )
47: RETURN VARCHAR2
48: IS
49: l_parameter pay_payroll_actions.legislative_parameters%TYPE := NULL;
50: l_start_pos NUMBER;
51: l_delimiter VARCHAR2 (1) := ' ';
52: l_proc VARCHAR2 (240) := g_package || ' get parameter ';
53: BEGIN

Line 140: FROM pay_payroll_actions

136: , 'YEAR'
137: )
138: ) L_YEAR
139: , /*FND_DATE.canonical_to_date(effective_date)*/ effective_date, business_group_id bg_id
140: FROM pay_payroll_actions
141: WHERE payroll_action_id = p_payroll_action_id;
142:
143: lr_parameter_info csr_parameter_info%ROWTYPE;
144: l_proc VARCHAR2 (240)

Line 442: pay_payroll_actions.payroll_action_id%type)

438: AND ue.business_group_id is NULL
439: AND ue.creator_type = 'B';
440:
441: CURSOR csr_assignment_action (csr_v_payroll_action_id
442: pay_payroll_actions.payroll_action_id%type)
443: IS
444: SELECT MAX(assignment_action_id)
445: FROM pay_Assignment_actions WHERE
446: payroll_action_id=csr_v_payroll_action_id; --23

Line 626: ,pay_payroll_actions ppa

622:
623: p_sql :=
624: 'SELECT DISTINCT person_id
625: FROM per_people_f ppf
626: ,pay_payroll_actions ppa
627: WHERE ppa.payroll_action_id = :payroll_action_id
628: AND ppa.business_group_id = ppf.business_group_id
629: ORDER BY ppf.person_id';
630: g_payroll_action_id := p_payroll_action_id;

Line 1966: FROM pay_payroll_actions ppa

1962: THEN
1963: BEGIN
1964: SELECT payroll_action_id
1965: INTO l_payroll_action_id
1966: FROM pay_payroll_actions ppa
1967: , fnd_conc_req_summary_v fcrs
1968: , fnd_conc_req_summary_v fcrs1
1969: WHERE fcrs.request_id = fnd_global.conc_request_id
1970: AND fcrs.priority_request_id = fcrs1.priority_request_id

Line 2117: pay_payroll_actions ppa,

2113: pai1.ACTION_INFORMATION11 Terminated,
2114: pai1.ACTION_INFORMATION12 Painter*/
2115: FROM
2116: pay_action_information pai,
2117: pay_payroll_actions ppa,
2118: pay_action_information pai1
2119: WHERE
2120: pai.action_context_id = ppa.payroll_action_id
2121: AND ppa.payroll_action_id =p_payroll_action_id --27021 --20162 --20264 --20165

Line 2153: pay_payroll_actions ppa,

2149: pai1.ACTION_INFORMATION11 Terminated,
2150: pai1.ACTION_INFORMATION12 Painter*/
2151: FROM
2152: pay_action_information pai,
2153: pay_payroll_actions ppa,
2154: pay_action_information pai1
2155: WHERE
2156: pai.action_context_id = ppa.payroll_action_id
2157: AND ppa.payroll_action_id =p_payroll_action_id --27021 --20162 --20264 --20165

Line 2185: pay_payroll_actions ppa,

2181: pai1.ACTION_INFORMATION12 Terminated,
2182: pai1.ACTION_INFORMATION13 Painter
2183: FROM
2184: --pay_action_information pai,
2185: pay_payroll_actions ppa,
2186: pay_action_information pai1
2187: WHERE
2188: pai1.action_context_id = ppa.payroll_action_id
2189: AND ppa.payroll_action_id =p_payroll_action_id --27021 --20162 --20264 --20165

Line 2251: FROM pay_payroll_actions ppa,

2247: IF p_payroll_action_id IS NULL THEN
2248: BEGIN
2249: SELECT payroll_action_id
2250: INTO l_payroll_action_id
2251: FROM pay_payroll_actions ppa,
2252: fnd_conc_req_summary_v fcrs,
2253: fnd_conc_req_summary_v fcrs1
2254: WHERE fcrs.request_id = fnd_global.conc_request_id
2255: AND fcrs.priority_request_id = fcrs1.priority_request_id