APPS.PAY_SE_SALARY_STRUCTURE_STATS 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 145: FROM pay_payroll_actions

141: , 'REPORT_YEAR'
142: )
143: ) L_REPORT_YEAR
144: , effective_date, business_group_id bg_id
145: FROM pay_payroll_actions
146: WHERE payroll_action_id = p_payroll_action_id;
147:
148: lr_parameter_info csr_parameter_info%ROWTYPE;
149: l_proc VARCHAR2 (240)

Line 360: ,pay_payroll_actions ppa

356:
357: p_sql :=
358: 'SELECT DISTINCT person_id
359: FROM per_people_f ppf
360: ,pay_payroll_actions ppa
361: WHERE ppa.payroll_action_id = :payroll_action_id
362: AND ppa.business_group_id = ppf.business_group_id
363: ORDER BY ppf.person_id';
364: g_payroll_action_id := p_payroll_action_id;

Line 2075: pay_payroll_actions ppa

2071: IS
2072: SELECT pai.action_information6 Report_Year
2073: FROM
2074: pay_action_information pai,
2075: pay_payroll_actions ppa
2076: WHERE
2077: ppa.payroll_action_id=csr_v_payroll_action_id--175110 --csr_v_payroll_action_id
2078: AND ppa.payroll_action_id=pai.action_context_id
2079: AND pai.action_context_type = 'PA'

Line 2128: pay_payroll_actions ppa

2124: pay_action_information pai1,
2125: pay_action_information pai2,
2126: pay_action_information pai3,
2127: pay_action_information pai4,
2128: pay_payroll_actions ppa
2129: WHERE
2130: ppa.payroll_action_id=csr_v_payroll_action_id --175110 --175079 --175068 --csr_v_payroll_action_id
2131: AND ppa.payroll_action_id=pai1.action_context_id
2132: AND pai1.action_context_id=pai2.action_context_id

Line 2169: pay_payroll_actions ppa

2165: SELECT nvl(COUNT(*),0) Local_Unit_Count
2166: FROM
2167: pay_action_information pai,
2168: pay_action_information pai1,
2169: pay_payroll_actions ppa
2170: WHERE
2171: ppa.payroll_action_id=csr_v_payroll_action_id --175110 --csr_v_payroll_action_id
2172: AND ppa.payroll_action_id=pai.action_context_id
2173: AND pai.action_context_id=pai1.action_context_id

Line 2224: FROM pay_payroll_actions ppa,

2220: IF p_payroll_action_id IS NULL THEN
2221: BEGIN
2222: SELECT payroll_action_id
2223: INTO l_payroll_action_id
2224: FROM pay_payroll_actions ppa,
2225: fnd_conc_req_summary_v fcrs,
2226: fnd_conc_req_summary_v fcrs1
2227: WHERE fcrs.request_id = fnd_global.conc_request_id
2228: AND fcrs.priority_request_id = fcrs1.priority_request_id