APPS.PAY_US_GEO_UPD_PKG dependencies on FF_CONTEXTS

Line 154: from ff_contexts

150: pay_us_modified_geocodes pmod
151: WHERE pmod.state_code = 'CA'
152: AND pmod.county_code = pac.context_value
153: AND pac.context_id in (select context_id
154: from ff_contexts
155: where context_name = 'JURISDICTION_CODE')
156: AND pmod.patch_name = l_patch_name
157: AND pac.assignment_id = paf.assignment_id
158: AND paf.person_id between stperson and endperson ;

Line 770: from ff_contexts

766: pay_us_modified_geocodes pmod
767: WHERE pmod.state_code = 'CA'
768: AND pmod.county_code = pac.context_value
769: AND pac.context_id in (select context_id
770: from ff_contexts
771: where context_name = 'JURISDICTION_CODE')
772: AND pmod.patch_name = p_patch_name
773: AND pac.assignment_id = paf.assignment_id
774: AND paf.assignment_id between P_ASSIGN_START and P_ASSIGN_END ;

Line 920: ff_contexts ffc

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

Line 951: ff_contexts ffc

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

Line 984: ff_contexts fcon

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
986: AND paa.assignment_action_id = plb.assignment_action_id
987: AND plb.person_id = personid
988: AND pbcv.latest_balance_id = plb.latest_balance_id

Line 1009: FROM ff_contexts fcon,

1005: --table.
1006: CURSOR pacv_cur(geocode VARCHAR2, assign_id NUMBER, personid NUMBER) IS
1007: SELECT distinct pbcv.context_id, pbcv.value, pbcv.latest_balance_id,
1008: plb.assignment_action_id
1009: FROM ff_contexts fcon,
1010: pay_balance_context_values pbcv,
1011: pay_assignment_latest_balances plb
1012: WHERE plb.assignment_id = assign_id
1013: AND pbcv.latest_balance_id = plb.latest_balance_id

Line 1037: FROM ff_contexts fcon,

1033:
1034: CURSOR plbcv_cur(geocode VARCHAR2, assign_id NUMBER, personid NUMBER) IS
1035: SELECT distinct pbcv.context_id, pbcv.value, pbcv.latest_balance_id,
1036: plb.assignment_action_id
1037: FROM ff_contexts fcon,
1038: pay_balance_context_values pbcv,
1039: pay_latest_balances plb
1040: WHERE plb.assignment_id = assign_id
1041: AND pbcv.latest_balance_id = plb.latest_balance_id