DBA Data[Home] [Help]

APPS.PAY_PEL_BUS dependencies on PAY_ELEMENT_LINKS_F

Line 31: , pay_element_links_f pel

27: --
28: cursor csr_sec_grp is
29: select pbg.security_group_id
30: from per_business_groups pbg
31: , pay_element_links_f pel
32: where pel.element_link_id = p_element_link_id
33: and pbg.business_group_id = pel.business_group_id;
34: --
35: -- Declare local variables

Line 95: , pay_element_links_f pel

91: --
92: cursor csr_leg_code is
93: select pbg.legislation_code
94: from per_business_groups pbg
95: , pay_element_links_f pel
96: where pel.element_link_id = p_element_link_id
97: and pbg.business_group_id = pel.business_group_id;
98: --
99: -- Declare local variables

Line 1432: fnd_message.set_token('TABLE_NAME','pay_element_links_f');

1428: close csr_legcode_cr_db_type;
1429:
1430: if l_costable_flag = 'N' and p_costable_type <> 'N' then
1431: fnd_message.set_name('PAY','PAY_33089_COST_FLAG_TYPE_MISMATCH');
1432: fnd_message.set_token('TABLE_NAME','pay_element_links_f');
1433: fnd_message.raise_error;
1434: end if;
1435:
1436: if p_costable_type = 'N'

Line 1805: l_qualifying_age pay_element_links_f.qualifying_age%TYPE;

1801: ) is
1802: --
1803: l_proc varchar2(72) := g_package||'update_validate';
1804:
1805: l_qualifying_age pay_element_links_f.qualifying_age%TYPE;
1806: l_qualifying_length_of_service
1807: pay_element_links_f.qualifying_length_of_service%TYPE;
1808: l_qualifying_units pay_element_links_f.qualifying_units%TYPE;
1809: l_multiply_value_flag pay_element_links_f.multiply_value_flag%TYPE;

Line 1807: pay_element_links_f.qualifying_length_of_service%TYPE;

1803: l_proc varchar2(72) := g_package||'update_validate';
1804:
1805: l_qualifying_age pay_element_links_f.qualifying_age%TYPE;
1806: l_qualifying_length_of_service
1807: pay_element_links_f.qualifying_length_of_service%TYPE;
1808: l_qualifying_units pay_element_links_f.qualifying_units%TYPE;
1809: l_multiply_value_flag pay_element_links_f.multiply_value_flag%TYPE;
1810: l_standard_link_flag pay_element_links_f.standard_link_flag%TYPE;
1811:

Line 1808: l_qualifying_units pay_element_links_f.qualifying_units%TYPE;

1804:
1805: l_qualifying_age pay_element_links_f.qualifying_age%TYPE;
1806: l_qualifying_length_of_service
1807: pay_element_links_f.qualifying_length_of_service%TYPE;
1808: l_qualifying_units pay_element_links_f.qualifying_units%TYPE;
1809: l_multiply_value_flag pay_element_links_f.multiply_value_flag%TYPE;
1810: l_standard_link_flag pay_element_links_f.standard_link_flag%TYPE;
1811:
1812:

Line 1809: l_multiply_value_flag pay_element_links_f.multiply_value_flag%TYPE;

1805: l_qualifying_age pay_element_links_f.qualifying_age%TYPE;
1806: l_qualifying_length_of_service
1807: pay_element_links_f.qualifying_length_of_service%TYPE;
1808: l_qualifying_units pay_element_links_f.qualifying_units%TYPE;
1809: l_multiply_value_flag pay_element_links_f.multiply_value_flag%TYPE;
1810: l_standard_link_flag pay_element_links_f.standard_link_flag%TYPE;
1811:
1812:
1813: --

Line 1810: l_standard_link_flag pay_element_links_f.standard_link_flag%TYPE;

1806: l_qualifying_length_of_service
1807: pay_element_links_f.qualifying_length_of_service%TYPE;
1808: l_qualifying_units pay_element_links_f.qualifying_units%TYPE;
1809: l_multiply_value_flag pay_element_links_f.multiply_value_flag%TYPE;
1810: l_standard_link_flag pay_element_links_f.standard_link_flag%TYPE;
1811:
1812:
1813: --
1814: Begin