APPS.PAY_CA_PMED dependencies on HR_ORGANIZATION_INFORMATION

Line 40: FROM hr_organization_information ogi1,

36: CURSOR csr_get_src_id2 (p_juris VARCHAR2,
37: p_gre NUMBER, p_bg_no NUMBER) IS
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

Line 41: hr_organization_information ogi2,

37: p_gre NUMBER, p_bg_no NUMBER) IS
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

Line 43: hr_organization_information ogi3,

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'
47: AND ogi1.org_information1 = 'HR_LEGAL'

Line 44: hr_organization_information ogi4

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'
47: AND ogi1.org_information1 = 'HR_LEGAL'
48: AND ogi1.org_information2 = 'Y'

Line 67: FROM hr_organization_information ogi1,

63: CURSOR csr_get_src_id3(p_juris VARCHAR2,
64: p_gre NUMBER, p_bg_no NUMBER) IS
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

Line 68: hr_organization_information ogi2,

64: p_gre NUMBER, p_bg_no NUMBER) IS
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

Line 70: hr_organization_information ogi3,

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'
74: AND ogi1.org_information1 = 'HR_LEGAL'

Line 71: hr_organization_information ogi4

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'
74: AND ogi1.org_information1 = 'HR_LEGAL'
75: AND ogi1.org_information2 = 'Y'