APPS.PAY_CN_AUDIT_XMLGEN dependencies on PAY_PAYROLL_ACTIONS

Line 131: pay_payroll_actions ppa

127: END IF ;
128:
129: p_sqlstr := 'SELECT DISTINCT person_id
130: FROM per_people_f ppf,
131: pay_payroll_actions ppa
132: WHERE ppa.payroll_action_id = :payroll_action_id
133: AND ppa.business_group_id +0 = ppf.business_group_id
134: ORDER BY ppf.person_id';
135:

Line 202: FROM pay_payroll_actions ppa,

198: )
199: AND ppf.business_group_id = g_bg_id
200: AND paf.business_group_id =g_bg_id
201: AND EXISTS (SELECT 1
202: FROM pay_payroll_actions ppa,
203: pay_assignment_actions paa
204: WHERE paa.assignment_id =paf.assignment_id
205: AND paa.payroll_action_id = ppa.payroll_action_id
206: AND ppa.action_type in('R','Q')

Line 225: from pay_payroll_Actions ppa,

221: -- 2010 01 Should come after 2009 12. So use period_num and year combination
222:
223: CURSOR c_get_periods(p_assignment_id IN NUMBER) IS
224: select distinct(to_CHAR(ppa.effective_date,'YYYY')||TO_CHAR(ppa.effective_date,'MM')||ppf.payroll_id) pnum
225: from pay_payroll_Actions ppa,
226: pay_assignment_actions paa,
227: pay_payrolls_f ppf
228: where paa.payroll_action_id = ppa.payroll_Action_id
229: and ppa.action_type in('R','Q')

Line 297: FROM pay_payroll_actions

293: CURSOR csr_parameter_info(p_pact_id NUMBER)
294: IS
295: SELECT legislative_parameters
296: ,business_group_id
297: FROM pay_payroll_actions
298: WHERE payroll_action_id = p_pact_id;
299:
300: l_token_value VARCHAR2(150);
301: l_bg_id NUMBER;

Line 307: token_val pay_payroll_actions.legislative_parameters%TYPE;

303: l_message VARCHAR2(255);
304: l_param_string VARCHAR2(1000);
305: start_ptr NUMBER;
306: end_ptr NUMBER;
307: token_val pay_payroll_actions.legislative_parameters%TYPE;
308:
309: BEGIN
310:
311: l_proc := g_proc_name||'get_parameters';

Line 557: pay_payroll_actions ppa,

553: paf.assignment_number,
554: max(paa.assignment_action_id) assignment_action_id,
555: ppf.payroll_name
556: FROM per_assignments_f paf,
557: pay_payroll_actions ppa,
558: pay_assignment_actions paa,
559: pay_payrolls_f ppf
560: WHERE paf.effective_start_date <= g_end_date
561: AND paf.effective_end_date >= g_start_date

Line 601: pay_payroll_actions ppa,

597: to_CHAR(decode(g_trfr_date_used,'E',ppa.date_earned,ppa.effective_date) ,'YYYY') acct_yr,
598: to_number(to_CHAR(decode(g_trfr_date_used,'E',ppa.date_earned,ppa.effective_date) ,'MM')) accnt_prd,
599: 'CNY' currency
600: from per_all_assignments_f paf,
601: pay_payroll_actions ppa,
602: pay_assignment_actions paa
603: where ppa.effective_date between paf.effective_start_date and paf.effective_end_date
604: and paf.assignment_id = p_assignment_id
605: and paa.assignment_id = paf.assignment_id

Line 845: from pay_payroll_actions arch_ppa,

841: select arch_paa.assignment_action_id asg_action_id ,
842: ppa.payroll_id payroll_id,
843: ppa.date_earned earn_date,
844: ppa.effective_date eff_date
845: from pay_payroll_actions arch_ppa,
846: pay_assignment_actions arch_paa,
847: pay_action_interlocks intl,
848: pay_payroll_Actions ppa,
849: pay_assignment_actions paa

Line 848: pay_payroll_Actions ppa,

844: ppa.effective_date eff_date
845: from pay_payroll_actions arch_ppa,
846: pay_assignment_actions arch_paa,
847: pay_action_interlocks intl,
848: pay_payroll_Actions ppa,
849: pay_assignment_actions paa
850: where arch_paa.assignment_action_id = intl.locking_action_id
851: and arch_paa.payroll_Action_id = arch_ppa.payroll_action_id
852: and arch_paa.source_action_id is not null

Line 1451: pay_payroll_actions

1447: request_id
1448: INTO
1449: ln_reqid_gle
1450: FROM
1451: pay_payroll_actions
1452: WHERE payroll_action_id = p_pactid;
1453:
1454: IF g_opt_soe_or_min IS NULL OR g_opt_soe_or_min = 'ENT' THEN
1455: l_file := per_cn_shared_info.get_lookup_meaning('SOE_NAME','CN_AUDIT_DATA');

Line 1548: pay_payroll_actions ppa ,

1544:
1545:
1546: sqlstr := ' select paa.rowid
1547: from pay_assignment_actions paa,
1548: pay_payroll_actions ppa ,
1549: per_people_f ppf,
1550: pay_payrolls_f p
1551: where ppa.payroll_action_id = :pactid
1552: and paa.payroll_action_id = ppa.payroll_action_id