APPS.PAY_PAYROLLS_F_PKG dependencies on HR_SOFT_CODING_KEYFLEX

Line 62: from hr_soft_coding_keyflex hsc

58: ) return number is
59: --
60: cursor csr_soft_coding_exists is
61: select hsc.soft_coding_keyflex_id
62: from hr_soft_coding_keyflex hsc
63: where hsc.soft_coding_keyflex_id = p_soft_coding_keyflex_id;
64: --
65: v_dummy number;
66: v_soft_coding_keyflex_id number := p_soft_coding_keyflex_id;

Line 95: from hr_soft_coding_keyflex s

91: -- Need to check for a partial value.
92: begin
93: select s.soft_coding_keyflex_id
94: into v_soft_coding_keyflex_id
95: from hr_soft_coding_keyflex s
96: where s.id_flex_num = p_scl_structure
97: and s.enabled_flag = 'Y'
98: and (s.segment1 = p_segment1
99: or (s.segment1 is null

Line 199: select hr_soft_coding_keyflex_s.nextval

195: if (v_soft_coding_keyflex_id = -1) then
196: --
197: -- select the next sequence value for the soft coding keyflex.
198: begin
199: select hr_soft_coding_keyflex_s.nextval
200: into v_soft_coding_keyflex_id
201: from sys.dual;
202: exception
203: when NO_DATA_FOUND then

Line 213: insert into hr_soft_coding_keyflex

209: end;
210: --
211: -- Insert the new row.
212: begin
213: insert into hr_soft_coding_keyflex
214: (soft_coding_keyflex_id
215: ,concatenated_segments
216: ,id_flex_num
217: ,last_update_date

Line 839: from hr_soft_coding_keyflex kf

835: ) is
836: --
837: cursor csr_bg_scl_segs is
838: select *
839: from hr_soft_coding_keyflex kf
840: where exists
841: (select null
842: from hr_all_organization_units org
843: where org.organization_id = p_business_group_id

Line 1902: l_scl_concat_segments HR_SOFT_CODING_KEYFLEX.concatenated_segments%TYPE;

1898: l_soft_coding_keyflex_id PAY_ALL_PAYROLLS_F.SOFT_CODING_KEYFLEX_ID%TYPE ;
1899:
1900: l_cost_concat_segments PAY_COST_ALLOCATION_KEYFLEX.concatenated_segments%TYPE ;
1901: l_susp_concat_segments PAY_COST_ALLOCATION_KEYFLEX.concatenated_segments%TYPE ;
1902: l_scl_concat_segments HR_SOFT_CODING_KEYFLEX.concatenated_segments%TYPE;
1903: --
1904: BEGIN
1905: --
1906: pay_payrolls_f_pkg.validate_insert_payroll

Line 2845: l_scl_concat_segments HR_SOFT_CODING_KEYFLEX.concatenated_segments%TYPE;

2841: l_suspense_account_keyflex_id PAY_ALL_PAYROLLS_F.SUSPENSE_ACCOUNT_KEYFLEX_ID%TYPE ;
2842: l_soft_coding_keyflex_id PAY_ALL_PAYROLLS_F.SOFT_CODING_KEYFLEX_ID%TYPE ;
2843: l_cost_concat_segments PAY_COST_ALLOCATION_KEYFLEX.concatenated_segments%TYPE ;
2844: l_susp_concat_segments PAY_COST_ALLOCATION_KEYFLEX.concatenated_segments%TYPE ;
2845: l_scl_concat_segments HR_SOFT_CODING_KEYFLEX.concatenated_segments%TYPE;
2846: --
2847: BEGIN
2848: --
2849: -- Find the current values for payroll name, default payment method and