APPS.PAY_US_GEO_UPD_PKG dependencies on FF_CONTEXTS

Line 316: from ff_contexts

312: pay_us_modified_geocodes pmod
313: WHERE pmod.state_code = 'CA'
314: AND pmod.county_code = pac.context_value
315: AND pac.context_id in (select context_id
316: from ff_contexts
317: where context_name = 'JURISDICTION_CODE')
318: AND pmod.patch_name = l_patch_name
319: AND pac.assignment_id = paf.assignment_id
320: AND paf.person_id between stperson and endperson ;

Line 979: from ff_contexts

975: pay_us_modified_geocodes pmod
976: WHERE pmod.state_code = 'CA'
977: AND pmod.county_code = pac.context_value
978: AND pac.context_id in (select context_id
979: from ff_contexts
980: where context_name = 'JURISDICTION_CODE')
981: AND pmod.patch_name = p_patch_name
982: AND pac.assignment_id = paf.assignment_id
983: AND paf.assignment_id between P_ASSIGN_START and P_ASSIGN_END ;

Line 1129: ff_contexts ffc

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'
1132: AND ppa.report_qualifier = 'FED'
1133: AND ppa.payroll_action_id = paa.payroll_action_id

Line 1160: ff_contexts ffc

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')
1163: and report_qualifier in ('FED','CAEOYRL1', 'CAEOYRL2', 'CAEOY', 'CAEOY')
1164: and ppa.payroll_action_id = paa.payroll_action_id

Line 1193: ff_contexts fcon

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
1195: AND paa.assignment_action_id = plb.assignment_action_id
1196: AND plb.person_id = personid
1197: AND pbcv.latest_balance_id = plb.latest_balance_id

Line 1218: FROM ff_contexts fcon,

1214: --table.
1215: CURSOR pacv_cur(geocode VARCHAR2, assign_id NUMBER, personid NUMBER) IS
1216: SELECT distinct pbcv.context_id, pbcv.value, pbcv.latest_balance_id,
1217: plb.assignment_action_id
1218: FROM ff_contexts fcon,
1219: pay_balance_context_values pbcv,
1220: pay_assignment_latest_balances plb
1221: WHERE plb.assignment_id = assign_id
1222: AND pbcv.latest_balance_id = plb.latest_balance_id

Line 1246: FROM ff_contexts fcon,

1242:
1243: CURSOR plbcv_cur(geocode VARCHAR2, assign_id NUMBER, personid NUMBER) IS
1244: SELECT distinct pbcv.context_id, pbcv.value, pbcv.latest_balance_id,
1245: plb.assignment_action_id
1246: FROM ff_contexts fcon,
1247: pay_balance_context_values pbcv,
1248: pay_latest_balances plb
1249: WHERE plb.assignment_id = assign_id
1250: AND pbcv.latest_balance_id = plb.latest_balance_id