APPS.PAY_CN_AUDIT_XMLGEN dependencies on PAY_ASSIGNMENT_ACTIONS

Line 203: pay_assignment_actions paa

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')
207: AND decode(g_trfr_date_used,'E',ppa.date_earned,ppa.effective_date) BETWEEN g_start_date AND g_end_date

Line 226: pay_assignment_actions paa,

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')
230: and ppa.payroll_id = ppf.payroll_id

Line 261: SELECT pay_assignment_actions_s.NEXTVAL

257: IF g_debug THEN
258: hr_utility.trace (' Picking Period NUmber '||q.pnum);
259: END IF;
260:
261: SELECT pay_assignment_actions_s.NEXTVAL
262: INTO l_actid
263: FROM dual;
264:
265:

Line 268: UPDATE pay_assignment_actions

264:
265:
266: hr_nonrun_asact.insact(l_actid,i.assignment_id,p_pactid,p_chunk,NULL);
267:
268: UPDATE pay_assignment_actions
269: SET serial_number = q.pnum
270: WHERE assignment_action_id = l_actid
271: AND assignment_id = i.assignment_id
272: AND payroll_action_id = p_pactid;

Line 558: pay_assignment_actions paa,

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
562: AND paf.business_group_id = g_bg_id

Line 602: pay_assignment_actions paa

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
606: and paa.payroll_action_id = ppa.payroll_action_id

Line 846: pay_assignment_actions arch_paa,

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
850: where arch_paa.assignment_action_id = intl.locking_action_id

Line 849: pay_assignment_actions paa

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
853: and arch_ppa.action_type='X'

Line 1012: l_mag_asg_action_id pay_assignment_actions.assignment_action_id%TYPE;

1008: --Variables-----
1009: l_common_xml VARCHAR2(4000);
1010: l_xml_begin VARCHAR2(200);
1011: l_xml2 VARCHAR2(40);
1012: l_mag_asg_action_id pay_assignment_actions.assignment_action_id%TYPE;
1013: l_assignment_id number;
1014: l_serial_number varchar2(500);
1015: l_pact number;
1016: l_ctr number;

Line 1030: pay_assignment_Actions

1026:
1027: select assignment_id,payroll_action_id,serial_number
1028: into l_assignment_id,l_pact,l_serial_number
1029: from
1030: pay_assignment_Actions
1031: where assignment_Action_id = p_assignment_action_id;
1032:
1033: IF g_year IS NULL then
1034: initialization_code(l_pact);

Line 1547: from pay_assignment_actions paa,

1543: initialization_code(payactid);
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