APPS.PAY_US_GEO_UPD_PKG dependencies on PAY_ASSIGNMENT_ACTIONS

Line 445: select pay_assignment_actions_s.nextval

441:
442: exit when c_actions_assignment%notfound;
443:
444: hr_utility.set_location('geocode_action_creation',4);
445: select pay_assignment_actions_s.nextval
446: into lockingactid
447: from dual;
448:
449: -- insert the action record.

Line 495: select pay_assignment_actions_s.nextval

491: exit when c_actions_run_bal%notfound;
492: --
493:
494: hr_utility.set_location('gocode_action_creation',7);
495: select pay_assignment_actions_s.nextval
496: into lockingactid
497: from dual;
498: --
499: /*Bug#7240914: if lv_no_of_chunks < 1 then assign all to chunk 1

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

560: ) is
561: begin
562:
563: sqlstr := 'select paa1.rowid
564: from pay_assignment_actions paa1, -- PYUGEN assignment action
565: pay_payroll_actions ppa1 -- PYUGEN payroll action id
566: where ppa1.payroll_action_id = :pactid
567: and paa1.payroll_action_id = ppa1.payroll_action_id
568: order by paa1.assignment_action_id

Line 1077: FROM pay_assignment_actions

1073:
1074: -- Bug 3319878 -- Breaked the query into two cursors i.e paa_cur and prr_cur.
1075: CURSOR paa_cur(assign_id NUMBER) IS
1076: SELECT assignment_action_id
1077: FROM pay_assignment_actions
1078: WHERE assignment_id = assign_id;
1079:
1080: CURSOR prr_cur(assign_action_id NUMBER,assign_id NUMBER) IS
1081: SELECT distinct prr.run_result_id,

Line 1106: pay_assignment_actions paa

1102: CURSOR pac_cur(assign_id NUMBER, context_id NUMBER) IS
1103: SELECT pac.context_id,
1104: pac.assignment_action_id
1105: FROM pay_action_contexts pac,
1106: pay_assignment_actions paa
1107: WHERE paa.assignment_id = assign_id
1108: AND pac.assignment_id = paa.assignment_id -- Bug# 3679984 added this to where clause
1109: AND paa.assignment_action_id = pac.assignment_action_id
1110: AND pac.context_id = context_id ;

Line 1127: pay_assignment_actions paa,

1123: SELECT distinct paa.assignment_action_id,
1124: faic.context old_juri_code, faic.archive_item_id, ffc.context_id
1125: FROM ff_archive_items fai,
1126: ff_archive_item_contexts faic,
1127: pay_assignment_actions paa,
1128: pay_payroll_actions ppa,
1129: ff_contexts ffc
1130: WHERE ppa.report_type = 'YREND'
1131: AND ppa.report_category = 'RT'

Line 1158: pay_assignment_actions paa,

1154: faic.archive_item_id,
1155: ffc.context_id
1156: FROM ff_archive_items fai,
1157: ff_archive_item_contexts faic,
1158: pay_assignment_actions paa,
1159: pay_payroll_actions ppa,
1160: ff_contexts ffc
1161: WHERE ppa.report_type in ('T4', 'T4A', 'RL1', 'RL2', 'YREND')
1162: and ppa.report_category in ('RT', 'CAEOYRL1', 'CAEOYRL2', 'CAEOY', 'CAEOY')

Line 1190: FROM pay_assignment_actions paa,

1186:
1187: CURSOR pbcv_cur(geocode VARCHAR2, assign_id NUMBER, personid NUMBER) IS
1188: SELECT distinct pbcv.context_id, pbcv.value, pbcv.latest_balance_id,
1189: plb.assignment_action_id
1190: FROM pay_assignment_actions paa,
1191: pay_balance_context_values pbcv,
1192: pay_person_latest_balances plb,
1193: ff_contexts fcon
1194: WHERE paa.assignment_id = assign_id

Line 1517: pay_assignment_actions paa

1513:
1514: SELECT count(*)
1515: INTO l_run_balance_count
1516: FROM pay_run_balances prb,
1517: pay_assignment_actions paa
1518: WHERE paa.assignment_id = p_assign_id
1519: AND paa.assignment_action_id = prb.assignment_action_id
1520: AND paa.assignment_id = prb.assignment_id
1521: AND prb.jurisdiction_code = p_old_juri_code