APPS.PAY_US_GEO_UPD_PKG dependencies on PAY_ASSIGNMENT_ACTIONS

Line 279: select pay_assignment_actions_s.nextval

275:
276: exit when c_actions_assignment%notfound;
277:
278: hr_utility.set_location('geocode_action_creation',4);
279: select pay_assignment_actions_s.nextval
280: into lockingactid
281: from dual;
282:
283: -- insert the action record.

Line 317: select pay_assignment_actions_s.nextval

313: exit when c_actions_run_bal%notfound;
314: --
315:
316: hr_utility.set_location('gocode_action_creation',7);
317: select pay_assignment_actions_s.nextval
318: into lockingactid
319: from dual;
320: --
321:

Line 365: from pay_assignment_actions paa1, -- PYUGEN assignment action

361: ) is
362: begin
363:
364: sqlstr := 'select paa1.rowid
365: from pay_assignment_actions paa1, -- PYUGEN assignment action
366: pay_payroll_actions ppa1 -- PYUGEN payroll action id
367: where ppa1.payroll_action_id = :pactid
368: and paa1.payroll_action_id = ppa1.payroll_action_id
369: order by paa1.assignment_action_id

Line 868: FROM pay_assignment_actions

864:
865: -- Bug 3319878 -- Breaked the query into two cursors i.e paa_cur and prr_cur.
866: CURSOR paa_cur(assign_id NUMBER) IS
867: SELECT assignment_action_id
868: FROM pay_assignment_actions
869: WHERE assignment_id = assign_id;
870:
871: CURSOR prr_cur(assign_action_id NUMBER,assign_id NUMBER) IS
872: SELECT distinct prr.run_result_id,

Line 897: pay_assignment_actions paa

893: CURSOR pac_cur(assign_id NUMBER, context_id NUMBER) IS
894: SELECT pac.context_id,
895: pac.assignment_action_id
896: FROM pay_action_contexts pac,
897: pay_assignment_actions paa
898: WHERE paa.assignment_id = assign_id
899: AND pac.assignment_id = paa.assignment_id -- Bug# 3679984 added this to where clause
900: AND paa.assignment_action_id = pac.assignment_action_id
901: AND pac.context_id = context_id ;

Line 918: pay_assignment_actions paa,

914: SELECT distinct paa.assignment_action_id,
915: faic.context old_juri_code, faic.archive_item_id, ffc.context_id
916: FROM ff_archive_items fai,
917: ff_archive_item_contexts faic,
918: pay_assignment_actions paa,
919: pay_payroll_actions ppa,
920: ff_contexts ffc
921: WHERE ppa.report_type = 'YREND'
922: AND ppa.report_category = 'RT'

Line 949: pay_assignment_actions paa,

945: faic.archive_item_id,
946: ffc.context_id
947: FROM ff_archive_items fai,
948: ff_archive_item_contexts faic,
949: pay_assignment_actions paa,
950: pay_payroll_actions ppa,
951: ff_contexts ffc
952: WHERE ppa.report_type in ('T4', 'T4A', 'RL1', 'RL2', 'YREND')
953: and ppa.report_category in ('RT', 'CAEOYRL1', 'CAEOYRL2', 'CAEOY', 'CAEOY')

Line 981: FROM pay_assignment_actions paa,

977:
978: CURSOR pbcv_cur(geocode VARCHAR2, assign_id NUMBER, personid NUMBER) IS
979: SELECT distinct pbcv.context_id, pbcv.value, pbcv.latest_balance_id,
980: plb.assignment_action_id
981: FROM pay_assignment_actions paa,
982: pay_balance_context_values pbcv,
983: pay_person_latest_balances plb,
984: ff_contexts fcon
985: WHERE paa.assignment_id = assign_id