APPS.PAY_CPT_BUS dependencies on PAY_CA_EMP_PROV_TAX_INFO_F

Line 16: pay_ca_emp_prov_tax_info_f.assignment_id%TYPE

12: -- ----------------------------------------------------------------------------
13: Procedure chk_assignment_id
14: (p_emp_province_tax_inf_id in number
15: ,p_assignment_id in
16: pay_ca_emp_prov_tax_info_f.assignment_id%TYPE
17: ,p_business_group_id in
18: pay_ca_emp_prov_tax_info_f.business_group_id%TYPE
19: ,p_effective_date in date
20: ,p_object_version_number in number

Line 18: pay_ca_emp_prov_tax_info_f.business_group_id%TYPE

14: (p_emp_province_tax_inf_id in number
15: ,p_assignment_id in
16: pay_ca_emp_prov_tax_info_f.assignment_id%TYPE
17: ,p_business_group_id in
18: pay_ca_emp_prov_tax_info_f.business_group_id%TYPE
19: ,p_effective_date in date
20: ,p_object_version_number in number
21: ) is
22: --

Line 1331: pay_ca_emp_prov_tax_info_f PR

1327: /* cursor csr_assigned is
1328: select PA.context_value from
1329: pay_action_contexts PA,
1330: ff_contexts C,
1331: pay_ca_emp_prov_tax_info_f PR
1332: where C.context_id = PA.context_id
1333: and C.context_name = 'JURISDICTION_CODE'
1334: and PA.context_value = PR.province_code
1335: and PA.assignment_id = PR.assignment_id

Line 1343: pay_ca_emp_prov_tax_info_f PR,

1339: cursor csr_assigned(p_csr_tmp_date in date) is
1340: select PA.context_value from
1341: pay_action_contexts PA,
1342: ff_contexts C,
1343: pay_ca_emp_prov_tax_info_f PR,
1344: pay_assignment_actions paa,
1345: per_assignments_f paf
1346: where C.context_id = PA.context_id
1347: and C.context_name = 'JURISDICTION_CODE'

Line 1417: pay_ca_emp_prov_tax_info_f b

1413: --
1414: cursor csr_leg_code is
1415: select a.legislation_code
1416: from per_business_groups a,
1417: pay_ca_emp_prov_tax_info_f b
1418: where b.emp_province_tax_inf_id = p_emp_province_tax_inf_id
1419: and a.business_group_id = b.business_group_id;
1420: --
1421: -- Declare local variables