APPS.PAY_CA_PMED dependencies on PAY_CA_PMED_ACCOUNTS

Line 31: FROM pay_ca_pmed_accounts pma

27: CURSOR csr_get_src_id1(p_juris VARCHAR2,
28: p_ac_no VARCHAR2,
29: p_bg_no number) IS
30: SELECT pma.source_id
31: FROM pay_ca_pmed_accounts pma
32: WHERE pma.account_number = p_ac_no
33: AND pma.enabled = 'Y'
34: AND pma.business_group_id = p_bg_no;
35:

Line 42: pay_ca_pmed_accounts pma,

38: SELECT pma.source_id,
39: pma.account_number
40: FROM hr_organization_information ogi1,
41: hr_organization_information ogi2,
42: pay_ca_pmed_accounts pma,
43: hr_organization_information ogi3,
44: hr_organization_information ogi4
45: WHERE ogi1.organization_id = p_gre
46: AND ogi1.org_information_context = 'CLASS'

Line 69: pay_ca_pmed_accounts pma,

65: SELECT pma.source_id,
66: pma.account_number
67: FROM hr_organization_information ogi1,
68: hr_organization_information ogi2,
69: pay_ca_pmed_accounts pma,
70: hr_organization_information ogi3,
71: hr_organization_information ogi4
72: WHERE ogi1.organization_id = p_gre
73: AND ogi1.org_information_context = 'CLASS'