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

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

Line 629: ,pay_payroll_actions ppa

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

Line 1992: FROM pay_payroll_actions ppa

1988: THEN
1989: BEGIN
1990: SELECT payroll_action_id
1991: INTO l_payroll_action_id
1992: FROM pay_payroll_actions ppa
1993: , fnd_conc_req_summary_v fcrs
1994: , fnd_conc_req_summary_v fcrs1
1995: WHERE fcrs.request_id = fnd_global.conc_request_id
1996: AND fcrs.priority_request_id = fcrs1.priority_request_id

Line 2143: pay_payroll_actions ppa,

2139: pai1.ACTION_INFORMATION11 Terminated,
2140: pai1.ACTION_INFORMATION12 Painter*/
2141: FROM
2142: pay_action_information pai,
2143: pay_payroll_actions ppa,
2144: pay_action_information pai1
2145: WHERE
2146: pai.action_context_id = ppa.payroll_action_id
2147: AND ppa.payroll_action_id =p_payroll_action_id --27021 --20162 --20264 --20165

Line 2179: pay_payroll_actions ppa,

2175: pai1.ACTION_INFORMATION11 Terminated,
2176: pai1.ACTION_INFORMATION12 Painter*/
2177: FROM
2178: pay_action_information pai,
2179: pay_payroll_actions ppa,
2180: pay_action_information pai1
2181: WHERE
2182: pai.action_context_id = ppa.payroll_action_id
2183: AND ppa.payroll_action_id =p_payroll_action_id --27021 --20162 --20264 --20165

Line 2213: pay_payroll_actions ppa,

2209: pai1.ACTION_INFORMATION14 Termination_Date, -- Bug#9440498 fix
2210: pai1.ACTION_INFORMATION15 Start_Date -- Bug#9440498 fix
2211: FROM
2212: --pay_action_information pai,
2213: pay_payroll_actions ppa,
2214: pay_action_information pai1
2215: WHERE
2216: pai1.action_context_id = ppa.payroll_action_id
2217: AND ppa.payroll_action_id =p_payroll_action_id --27021 --20162 --20264 --20165

Line 2280: FROM pay_payroll_actions ppa,

2276: IF p_payroll_action_id IS NULL THEN
2277: BEGIN
2278: SELECT payroll_action_id
2279: INTO l_payroll_action_id
2280: FROM pay_payroll_actions ppa,
2281: fnd_conc_req_summary_v fcrs,
2282: fnd_conc_req_summary_v fcrs1
2283: WHERE fcrs.request_id = fnd_global.conc_request_id
2284: AND fcrs.priority_request_id = fcrs1.priority_request_id